Thread
:
=max(range includes #N/As)
View Single Post
#
2
kk
Posts: n/a
Hi David,
Try...
=MAX(IF(ISNUMBER(YourRange),YourRange))
Array enter.
"David" wrote in message
...
Could anyone kindly suggest an arrray formula that will return the max value
of non #N/A values in a range?
TIA
--
David
Reply With Quote