User Posts: Mashhura
There are many ways of calculating Depreciation. Units of Production is one of them. The main objective of this article is to explain how to calculate the ...
Mashhura
If you are looking for a way to calculate NPV for monthly cash flows then you have come to the right place. The focus of this article is to explain how to ...
A data table helps to represent data more clearly in an Excel chart. If you are looking for a way of editing a data table in an chart then you have come to the ...
The Sunburst Chart in Excel is generally used for displaying hierarchical data. Each ring of the chart represents each level of the hierarchy. The data in a ...
If you are looking for a way to translate language with formula in VBA then you have come to the right place. Excel doesn’t provide a function for translation. ...
If you are looking for a way to change the date range in an Excel chart easily and quickly then you have come to the right place. The objective of this article ...
The COUNTIFS function gives you the opportunity to provide more than one criterion and returns the count of cells that meet all the criteria at the same time. ...
The COUNTIF function is one of the statistical functions. This function is used to count cells that meet a certain criterion. The focus of this article is to ...
Whenever working with Excel, you may face situations where you will need to translate your file or data into other languages. This article aims to explain how ...
![[Fixed!] Excel VLOOKUP Not Returning Correct Value](https://www.exceldemy.com/wp-content/uploads/thumbs_dir/9.-vlookup-not-returning-correct-value-201lqmgh9attxhxxaw6hm77fbzs4qp88ahb8lvswjof0.png)
Excel VLOOKUP function is a very useful function. You can find out your needed data from a big range of data easily by using the VLOOKUP function. But ...
![[Fixed!] Excel Filter Not Working After Certain Row](https://www.exceldemy.com/wp-content/uploads/thumbs_dir/2.-Excel-Filter-Not-Working-After-Certain-Row-201gohnb4zndvyh62y6nz48loo6pc86lbtg4cfmlvomc.png)
Excel Filter feature helps to filter data according to your need. It is a really helpful feature. But, sometimes it does not work properly. The objective of ...
![[Fixed!] Move or Copy Sheet Not Working in Excel](https://www.exceldemy.com/wp-content/uploads/thumbs_dir/11.-Move-or-Copy-Sheet-in-Excel-Not-Working-200sjexmn1dkf1pb5xpx85lydykhjf3abvxe9fargox0.png)
Move or Copy sheet is a very useful feature in Excel. You can move or copy worksheets by using this feature. But, sometimes you may face a situation when the ...
If you are looking for a way to convert your Excel file to Google Sheets then you have come to the right place. The objective of this article is to explain how ...
If you copy a pivot table and then paste it, you will get the pivot table. But, if you want to copy the values of a pivot table with the formatting, it can be ...
If you are looking for a way to convert an Excel file to VCF without using any software, this article will be helpful for you. The focus of this article is to ...
- 1
- 2
- 3
- …
- 6
- Next Page »
” title=”
Hello JC,
Thanks for your comment. I am replying to you on behalf of ExcelDemy. The downloaded file works for me.
You can follow the steps from the Feature of Eisenhower Matrix Template in Excel section. If it still doesn’t work then check if all cells contain the formula in the Eisenhower Matrix.
And, while making your own Eisenhower Matrix, check if you are applying for the same range as in this article. If not, change your ranges accordingly in the formula.
Lastly, if you are using an older version of Microsoft Excel then press Ctrl + Shift + Enter while entering the formula.
I hope this will help you to solve your problem. If none of these works then you can let us know at [email protected] with your Excel file and problem details. We will try our best to solve your problem.
Regards
Mashhura
ExcelDemy
Hi SEM,
Thanks for your comment. I am replying to you on behalf of ExcelDemy. If you want to filter dates older than a number of days from today, you can follow the steps from Method-2. But, instead of the formula used here, write the following formula.
=C5<(TODAY()-30)Here, I wrote the formula for dates older than 30 days from today. You can change the formula according to your preference.
I hope this will help you to solve your problem. Please let me know if you have other queries.
Regards
Mashhura
ExcelDemy
Hi Penny,
If you check to see if the cells are blank or not then they will be evaluated as not blank because the cells contain formula. If you need blank cells then you can follow these steps.
Step-01: In a Helper Column use any of the formulas from this article. But instead of an empty string (
"") write a letter or a special character ("#") in the formula.=IF((D5*E5)>2000,D5*E5,”#”)Step-02: Copy the values from the Helper Column and Paste them as Values where you want the final output.
Step-03: Press Ctrl + H and the Find and Replace dialog box will appear. Replace # with nothing and you will get your blank cells.
Finally, if you check the cells, then you will see the cells are blank.
I have shared the necessary images for your convenience. I hope this will solve your problem. Please let me know if you have other queries.
Thanks!
Hello DQNOK,
Thank you for your feedback.
Hello Frank,
This article contains different methods for different situations. Method 1.3 hides the numbers that are less than Zero. But, if you want to hide zeros only then you can try the following code.
Option ExplicitSub Hide_Rows_With_Zero()Dim row As LongDim col As LongDim qq As BooleanFor row = 6 To 14qq = TrueFor col = 2 To 4If Cells(row, col).Value <> 0 Thenqq = FalseExit ForEnd IfNext colRows(row).Hidden = qqNext rowEnd SubI hope this will help you to solve your problem. Please let us know if you have other queries.
Thanks!