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? →
How to find missing values using IF formula?
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? →
How to Get nth day of year in excel?
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? →
How to count cells without errors?
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 …
How to count characters total in a range?
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? →
How to count data that ends with a particular value?
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? →