match #n/a problem
Try something like
=MAX(IF(ISNUMBER(A1:A10),A1:A10))
array entered with ctrl + shift & enter
regards,
Peo Sjoblom
-----Original Message-----
I have a range of cells selected. Within that range is
some "#N/A" and
numbers. I am wanting to find the row of the largest
number in the range.
Thanks in advance.
--
.
|