=max(range includes #N/As)

D

David

Could anyone kindly suggest an arrray formula that will return the max value
of non #N/A values in a range?
TIA
 
K

kk

Hi David,

Try...

=MAX(IF(ISNUMBER(YourRange),YourRange))

Array enter.



Could anyone kindly suggest an arrray formula that will return the max value
of non #N/A values in a range?
TIA
 
Top