How to get maximum and minimum values in a range of cells which has #NA

[adonisolivar]

Hi I need your help on how to get the maximum or minimum values if your having #NA.
This #NA is a result of my formula in a cell I used. Example if I have A1:Z1 range of data.
I want to get the maximum values, How to get the max? Thank you so much.

 

[Jonmo1]

Welcome to the board.

I would recommend adjusting the formulas that return #N/A so that they don't return the error.

If you have XL 2007+ You can use something like
=IFERROR(yourformula,"")

so if your formula is a vlookup like
=VLOOKUP(A1,Sheet2!A:B,2,FALSE)

Then change it to
=IFERROR(VLOOKUP(A1,Sheet2!A:B,2,FALSE),"")


Then your MAX and MIN Functions will have no issue on the results of those formulas.