In this tutorial. We will learn three practical examples of how to swap axis in Excel. Excel charts are frequently used in reports and corporate ...
Md. Abdur Rahim Rasel
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
![[Solved!]: Excel COUNTIF Returning 0 Instead of Actual Value](https://www.exceldemy.com/wp-content/uploads/2022/11/COUNTIF-Function-Is-Returning-0-in-Excel-1-1.png)
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 ...
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, ...
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 ...
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 ...
![[Solved]: Macro Settings Greyed out in Excel](https://www.exceldemy.com/wp-content/uploads/2022/11/How-to-Enable-Macro-Settings-Greyed-out-in-Excel-1.png)
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 ...
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 ...
Have you ever found yourself spending too much time manually recreating charts in Microsoft Word that you've already created in Excel? Fear not, because we ...
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 ...
- 1
- 2
- 3
- …
- 12
- Next Page »
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)
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)
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.
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)
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))),"")→ 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→ 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
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)