If you are dealing with loads of data and you need to know the maximum value in the range, but there many errors present in the range too. This is …

Continue Reading about How to get Max Value ignoring errors in a range? →

Microsoft Excel Tutorials

posted on

If you are dealing with loads of data and you need to know the maximum value in the range, but there many errors present in the range too. This is …

Continue Reading about How to get Max Value ignoring errors in a range? →

posted on

When you are dealing with loads of data and you need to check for whether a particular value/ number/ product/ order is in the category or not, this …

Continue Reading about How to find missing values using IF formula? →

posted on

To calculate the no. of day in a year from a particular date, we will use the DATE Function and YEAR Function. Here’s an example, to elaborate …

Continue Reading about How to Get nth day of year in excel? →

posted on

If you want to count the cells in the range that do not contain errors, then we can use the SUMPRODUCT Function, NOT Function, and ISERR …

posted on

To count the total characters, present in a particular cell, you can use the LEN Function. By characters we mean, anything present in the cell, be it …

Continue Reading about How to count characters total in a range? →

posted on

In this space, we will learn how to count data that ends with a particular value e.g. RSVPUP-12-P, here, P is the ending value of the cell. When …

Continue Reading about How to count data that ends with a particular value? →

- « Go to Previous Page
- Go to page 1
- Go to page 2
- Go to page 3
- Go to page 4
- Go to page 5
- Interim pages omitted …
- Go to page 33
- Go to Next Page »