Thread: LOOKUP
View Single Post
  #1   Report Post  
George W. Barrowcliff
 
Posts: n/a
Default LOOKUP

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