User Posts: Mashhura
0
Units of Production Depreciation Method with Formula in Excel
0

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

0
Calculate NPV for Monthly Cash Flows with Formula in Excel
0

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

0
How to Edit Data Table in Excel Chart (2 Simple Ways)
0

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

0
How to Sort Excel Sunburst Chart Order (2 Ideal Examples)
0

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

0
Excel VBA to Translate Language with Formula (With Easy Steps)
0

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

0
How to Change Date Range in Excel Chart (3 Quick Ways)
0

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

0
How to Use COUNTIFS for Cells Not Equal to Multiple Text in Excel
0

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

0
How to Use COUNTIF for Non Contiguous Range in Excel
0

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

0
How to Translate Excel File from English to Gujarati (2 Easy Ways)
0

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

0
[Fixed!] Excel VLOOKUP Not Returning Correct Value
0

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

0
[Fixed!] Excel Filter Not Working After Certain Row
0

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

0
[Fixed!] Move or Copy Sheet Not Working in Excel
0

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

0
How to Convert Excel File to Google Sheets Automatically (3 Ways)
0

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

0
How to Copy and Paste Pivot Table Values with Formatting in Excel
0

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

0
How to Convert Excel to VCF Without Software (With Easy Steps)
0

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

Browsing All Comments By: Mashhura
  1. 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

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

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

  4. Hello DQNOK,
    Thank you for your feedback.

  5. 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 Explicit
    Sub Hide_Rows_With_Zero()
    Dim row As Long
    Dim col As Long
    Dim qq As Boolean
    For row = 6 To 14
    qq = True
    For col = 2 To 4
    If Cells(row, col).Value <> 0 Then
    qq = False
    Exit For
    End If
    Next col
    Rows(row).Hidden = qq
    Next row
    End Sub

    I hope this will help you to solve your problem. Please let us know if you have other queries.
    Thanks!

ExcelDemy
Logo