Max value ignore all errors

If you are working on any numerical data on the excel sheet that has many errors and you want to find out the maximum value in the data. Correction of each error may waste your precious time. So, you easily calculate the maximum value from your data using max value ignore all errors task through Excel Aggregate function. Here, we will show how to obtain maximum value by ignoring all other errors in excel spreadsheet.

Formula

To perform max value ignore all error in excel spreadsheet, the following formula will be used:

=AGGREGATE(4,6,values)

How Does this Formula work?

You can use max value ignore all error with an Aggregate function to find the maximum value and ignoring all other numerical errors in the excel data sets. In the formula mentioned above, number 4 and number 6 specify average and a choice to ignore data errors respectively. Value is the specified range across the excel data set.

Example 1

In the screenshot below, I have performed max value ignore all errors function in excel spreadsheet. The result indicates that the maximum value obtained is 60. See screenshot.

Figure 1. Example of Max Value Ignore All Errors in Excel

Example 2

The Graphics Interchange Format to perform max value ignore all errors function in excel

Figure 2. Illustration of Max Value Ignore All Errors

MAXIFS is an Alternative of Max Value Ignore All Errors

MAXIFS is the best alternative of Max Value Ignore All Errors as it can give the maximum value in a data set. If the data set value is positive, then using the following formula you can get the maximum  number thereby ignoring all the errors:

=MAXIFS(values,values,">=0")

In the formula mentioned above,  “greater” or “equal to zero” expression successfully filters out error values and provides the maximum value in a data set from the remaining eight values.  

 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar