User Posts: Md. Abdur Rahim Rasel
A Cash Book format in Excel is a straightforward layout created to keep track of all daily cash transactions carried out by a business. This Excel cash book ...
Md. Abdur Rahim Rasel
By default, the Gridlines are shown as gray lines in an Excel file. Those lines help us better visualize the data. However, we may want to hide the Gridlines ...
Sometimes we may need to calculate the average of numbers from a column in Excel. Average means the mean value of the input numbers. When we want to calculate ...
While working with Microsoft Excel, sometimes we need to nest formulas so that we can get our desired output with less effort or without effort. Nesting ...
A watermark is a logo, text, picture, or pattern. We usually superimpose it onto another image or dataset intentionally. The main purpose of a watermark is to ...
Sometimes you may need to export HTML table to Excel with formatting for the convenience of your work. To gain a clear grasp of this topic, you have to know ...
While working in Microsoft Excel sometimes we need to use VBA code for the submit button in Excel. We can easily do that in Excel. This is also a time-saving ...
An Excel spreadsheet is a terrific tool for making a daily schedule that will keep you organized and up to date with all of your commitments. Even if the ...
While working in Microsoft Excel with the sales-related worksheets, sometimes we need to change the Y axis scale for the convenience of our work. The chart ...
Sometimes you may need to create a world time zone clock in Excel for the convenience of your work. To gain a clear grasp of this topic, you have to know about ...
In this article, I will discuss how you can filter by multiple colors in Microsoft Excel. Usually, when we filter a certain column by multiple colors, other ...
We often use hours in our worksheets for business purposes, educational purposes, and many others. Sometimes, we need to convert hours to percentages in the ...
We often use time in our worksheets for business purposes, educational purposes, and many others. Sometimes, we need to add or subtract time in the worksheet. ...
While working with Microsoft Excel, sometimes we need to calculate the date which is greater than 2 years for the convenience of our work. Calculating a date ...
Excel is the most widely used tool for dealing with huge datasets. We can perform myriads of tasks of multiple dimensions in Excel. Sometimes, we take the help ...
- 1
- 2
- 3
- …
- 11
- Next Page »
” title=”
Hello RAVI
Thank you for your comment. When you are identifying the specific text from a string using Excel formulas, the specific text is known by you. So, I think if the return of the Excel formulas is TRUE you will be able to identify that specific text otherwise it returns FALSE. That’s why I think the above formula is appropriate to find out the specific text from a string. According to your question, I will introduce you to an efficient Excel function named the IF function to get the specific text. The IF function is,
=IF(E4=”YES”,D4,”Unable to Find Result”)Look at the below screenshot.
For the convenience of your work, please download the below Excel file which is provided by Exceldemy:
https://www.exceldemy.com/wp-content/uploads/2022/08/Excel-If-Range-of-Cells-Contains-Specific-Text.xlsx
If the answer doesn’t fulfill your query, feel free to comment. Our Exceldemy Team is always there to help.
Hello MARK,
To solve your ###### issue in the calculation field simply AutoFit the column width. You can AutoFit the column width like below screenshot.
Thank you for your comment.
Hello JACK,
You can easily do that using the Custom Sort command. Let’s follow the instructions below:
Let’s Sales volumes less than 40 are marked with low performance. Sales volumes greater than 40 but less than 60 are marked with medium performance. Sales volumes greater than 60 are marked with high performance.
First of all, select cells range E5 to F14, and press right-click. As a result, a window pops up. From that window select Custom Sort under the Sort option.
After that, do like the below screenshot.
Finally, you will get your desired output.
Please download the below Excel file for your practice.
https://www.exceldemy.com/wp-content/uploads/2022/08/Advanced-Sorting-Options.xlsx
Thank you for your comment.
Regards
Md. Abdur Rahim Rasel(Exceldemy Team)
Hi TONY!
We checked the Excel file. It is working fine for an even and uneven amount of characters. Make sure the TRIM function and the text to the column are entered correctly. We suggest you download the file and practice there. If you are unable to solve your problem, you can also share your Excel file with us.
Thank you for being with us.
Regards
Md. Abdur Rahim Rasel(Exceldemy Team)
Hi TERRY MUNDY!
You can easily make the output cell permanent through you will delete the original Date and Time cells. First of all, use Ctrl + C on your keyboard to copy the output cell. Hence, use the paste special features to paste the value only from your Home ribbon. After that, you can delete the original Date and Time cells, the output cell will become permanent. Look at the below screenshot.
Thank you for your question.
Regards
Md. Abdur Rahim Rasel (Exceldemy Team)
Hi AHMAD KHAN!
This article is how to Convert Formula to Value Without Paste Special in Excel. You can convert Formula in Value using the Keyboard shortcuts(F9), Right-Click Drag Down Option, Notepad to Convert Formula in Value, VBA code, Power Query, and so on. One suitable example is given below regarding your questions.
Suppose we have a data set that contains securing marks and results on Physics of several students of XYZ school. If a student secures less than 50, his/her result will Fail, and more than or equal to 50, his/her result will Pass. We will apply the IF function to do that. Let’s follow the instructions below.
First of all, select the formula in the Formula bar, then press F9.
As a result, you will be able to convert the formula to value without paste special.
Please repeat the procedure for the rest of the cells in column D.
Please download the Excel file for your practice.
https://www.exceldemy.com/wp-content/uploads/2022/09/Convert-Formula-to-Value-Without-Paste-Special.xlsx
Thank you for your comment.
Personal Email for sending your Excel sheet: [email protected]
Regards
Md. Abdur Rahim Rasel (Exceldemy Team)
Hi AHMAD!
I have checked all of the solutions of the above article again that can figure out how to make the mouse scroll in excel. I think the article is appropriate to solve the vertical scroll not working problem in Excel. You can disable the Automatically hide scroll bars in the windows option in windows 11 pro from the setting option under the start menu bar.
Thank you for your comment.
If you cannot solve your problem, please mail me personally at below mail address.
[email protected]
Regards
Md. Abdur Rahim Rasel (Exceldemy Team)
Hellow VADAKKUS!
To get the Stocks of the Indian Index instead of the NASDAQ Index, please use the below link in Method 3. The link is: https://www.moneycontrol.com/markets/indian-indices/
Thank you for your comment.
Regards
Md. Abdur Rahim Rasel (Exceldemy Team)
Welcome for your feedback, KURGAN 2020.
Regards
Md. Abdur Rahim Rasel (Exceldemy Team)
Hi GABRIEL!
Thank you for your comment.
The RATE function does not work for some combinations. In these cases, the #NUM! error occurs. To solve this error simply add the Type and the Guess arguments in the RATE function. For Type, 0 or omitted is used for at the end of the period and 1 is used for at the beginning of the period. If RATE does not converge, try different values for the guess. RATE usually converges if the guess is between 0 and 1.
Using these two arguments, you can solve the #NUM! Error. Look at the below screenshot.
Please download the Excel file for your practice.
https://www.exceldemy.com/wp-content/uploads/2022/09/Calculate-Yield-to-Maturity.xlsx
Regards
Md. Abdur Rahim Rasel (Exceldemy Team)