User Posts: Md. Abdur Rahim Rasel
0
How to Create Daily Cash Book Format in Excel (with Easy Steps)
0

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 ...

0
How to Hide Gridlines in Excel (7 Easy Methods)
0

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 ...

0
How to Calculate Average If Cell Is Not Blank in Excel
0

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 ...

0
Nested IF and AND Functions in Excel (4 Suitable Examples)
0

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 ...

0
How to Move Watermark in Excel (with Easy Steps)
0

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 ...

0
How to Export HTML Table with Formatting to Excel
0

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 ...

0
How to Use VBA Code for Submit Button in Excel (with Easy Steps)
0

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 ...

0
How to Make a Daily Schedule in Excel (6 Practical Examples)
0

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 ...

0
How to Change Y Axis Scale in Excel (with Easy Steps)
0

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 ...

0
How to Create World Time Zone Clock in Excel (2 Easy Methods)
0

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 ...

0
How to Filter by Multiple Colors in Excel (2 Easy Methods)
0

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 ...

0
How to Convert Hours to Percentage in Excel (3 Easy Methods)
0

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 ...

0
How to Add 30 Minutes to Time in Excel (3 Easy Methods)
0

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. ...

0
Excel Formula If Date Is Greater Than 2 Years (3 Examples)
-1

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 ...

1
How to Analyze Quantitative Data in Excel (with Easy Steps)
0

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 ...

Browsing All Comments By: Md. Abdur Rahim Rasel
  1. Reply
    Md. Abdur Rahim Rasel Aug 22, 2022 at 5:40 PM

    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.

  2. Reply
    Md. Abdur Rahim Rasel Aug 29, 2022 at 9:10 AM

    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.

  3. Reply
    Md. Abdur Rahim Rasel Aug 30, 2022 at 10:51 AM

    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.
    Custom Sort
    After that, do like the below screenshot.
    Custom Sort
    Finally, you will get your desired output.
    Custom Sort
    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)

  4. Reply
    Md. Abdur Rahim Rasel Aug 30, 2022 at 1:25 PM

    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)

  5. Reply
    Md. Abdur Rahim Rasel Sep 4, 2022 at 2:56 PM

    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.
    excel date and time in one cell
    Thank you for your question.
    Regards
    Md. Abdur Rahim Rasel (Exceldemy Team)

  6. Reply
    Md. Abdur Rahim Rasel Sep 19, 2022 at 11:24 AM

    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.
    Convert Formula to Value Without Paste Special in Excel
    As a result, you will be able to convert the formula to value without paste special.
    Convert Formula to Value Without Paste Special in Excel
    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)

  7. Reply
    Md. Abdur Rahim Rasel Sep 25, 2022 at 1:20 PM

    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)

  8. Reply
    Md. Abdur Rahim Rasel Oct 4, 2022 at 1:40 PM

    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)

  9. Reply
    Md. Abdur Rahim Rasel Sep 25, 2022 at 9:54 AM

    Welcome for your feedback, KURGAN 2020.
    Regards
    Md. Abdur Rahim Rasel (Exceldemy Team)

  10. Reply
    Md. Abdur Rahim Rasel Sep 4, 2022 at 4:29 PM

    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.
    calculate yield to maturity
    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)

ExcelDemy
Logo