View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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.
--



.