Hi David,
You're welcome. Thanks for the feedback.


"David" wrote in message
...
Thanks kk
--
David


"kk" wrote:

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