Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

User Posts: Md. Abdur Rahim Rasel
0
How to Insert an Embedded Text Box in Excel (4 Easy Ways)
0

In Microsoft Excel, we can insert multiple types of text boxes. But, those text boxes remain floated in the worksheet. As a result, it moves from one place to ...

0
How to Use FACTDOUBLE Function in Excel (4 Examples)
0

While dealing with Microsoft Excel, sometimes we need to calculate the double factorial of an integer. The FACTDOUBLE function is a built-in function that ...

0
How to Put Pi by Using Formula in Excel (4 Suitable Examples)
0

In mathematics, the constant Pi is utilized in calculations. In short, PI is the ratio of a circle's diameter to its circumference. While in mathematics, we ...

0
How to Create Metadata in Excel (4 Easy Ways)
0

When you prepare, access, or publish a Microsoft Excel workbook, it can have content that you do not wish to expose to others while sending the workbook ...

0
How to Set Limit for Visible Area in Excel (3 Ways)
0

When we have a very large datasheet, sometimes we need to set the limit for visible areas in Excel. Restricting rows and columns manually may take some extra ...

0
How to Delete a Data Table in Excel (4 Easy Ways)
0

While using Microsoft Excel, sometimes we need to delete or remove a data table. In this tutorial, I will show you four quick tricks to delete a data table in ...

0
[Solved!]: Excel COUNTIF Returning 0 Instead of Actual Value
0

Excel COUNTIF function counts values that match criteria from a range. You may sometimes face the issue that the function is returning 0. Today, in this ...

0
How to Add Blue Data Bar in Excel (3 Easy Ways)
0

We occasionally need to use the data bars feature to display our dataset. We can rapidly do it with Excel's conditional formatting feature. In this tutorial, ...

0
SUMPRODUCT and COUNTIF Functions with Multiple Criteria
0

The SUMPRODUCT and COUNTIF functions in Excel count the number of cells within a range that meet a given condition. You cannot apply multiple conditions with ...

0
How to Concatenate with VLOOKUP in Excel (4 Easy ways)
0

While working in Microsoft Excel, there are various formulas to make our work easier. The VLOOKUP formula is one of them. It has a wide range of applications ...

0
[Solved]: Macro Settings Greyed out in Excel
0

It is risky to activate macros because problems could arise when viewing a spreadsheet that has macros enabled. Due to security concerns, Excel disables macros ...

0
How to Save a Copy of an Excel File (3 Easy Ways)
0

This tutorial will demonstrate how to save a copy of an Excel file with a new name. If you have a particular Excel file that you need to use repeatedly, then ...

0
How to Copy a Chart from Excel to Word (2 Easy Ways)
0

While working in Microsoft Excel, we often have to create a Chart to understand data easily. Sometimes we need to copy a chart from Excel to Word for the ...

0
Calculate Forecast Confidence Interval in Excel (with Easy Steps)
0

While dealing with the sales of a company, sometimes we need to forecast the sales of that company to predict the profit or loss. In this case, Microsoft Excel ...

0
How to Rename a Sheet Without Using Mouse in Excel (2 Ways)
0

While working in Excel, we often have to rename a sheet. Properly named and organized worksheets are important for the look of the spreadsheet. For those who ...

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

    Hello 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 Oct 15, 2022 at 3:13 PM

    Hello BABA,
    I have checked all of the methods of the above article again that can figure out how to refresh chart in excel. I think the article is appropriate to refresh chart in Excel. While removing data from the dataset, I would not get any error. Look at the below screenshot.
    refresh chart
    Thank you for your comment.
    If you get error, please mail me personally at below mail address.
    [email protected]
    Regards
    Md. Abdur Rahim Rasel (Exceldemy Team)

  10. Reply
    Md. Abdur Rahim Rasel Oct 27, 2022 at 12:37 PM

    Hello, ROB!
    Thanks for sharing your problem with us!
    Let’s say, we have a dataset that contains several projects and project managers. You can know how many projects are shared among each pair of project managers by applying the IF, COUNTIF, ROW, INDEX, and SMALL functions. Hence, you can concatenate the projects with project managers using the Ampersand symbol.
    Let’s follow the instructions below to solve your problem!
    → First of all, Select cell F5 and write down the below screenshot’s functions in that cell. Hence, press Enter on your keyboard to get your desired output.
    =IF(COUNTIF($B$4:$B$16,$E$5)>=ROWS($1:1),INDEX($C$4:$C$16,SMALL(IF($B$4:$B$16=$E$5,ROW($4:$16)),ROW(1:1))),"")
    COUNTIF with Multiple Criteria
    → Further, AutoFill the functions to the rest of the cells in column F.

    → Now, we will concatenate a project and the project managers under that project. Insert the below formula into the formula bar.
    =$E$5&" "&F5
    COUNTIF with Multiple Criteria
    → Hence, AutoFill the formula to the rest of the cells in column G.

    Please download the Excel file for your practice.
    https://www.exceldemy.com/wp-content/uploads/2022/10/COUNTIF-with-Multiple-Criteria.xlsx
    Again Thank you for your comment.
    Regards
    Md. Abdur Rahim Rasel
    Exceldemy Team

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

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