LOOKUP

[George W. Barrowcliff]

Range is:
A1:K20 with numbers in the columns
I need a lookup that would return the highest non-blank value in a specified
column. A2,A1:K20,Highest Nonblank,

Thanks for any insight, GWB



i.e.
Jan Feb Mar etc
1990 456 34 34
1991 43 6
1992 12 11
etc

 

[Guest]

Why not just use the MAX function or am I missing something?