| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
Why not just use the MAX function or am I missing something?
"George W. Barrowcliff" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup more than one cell | Excel Worksheet Functions | |||
| Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Lookup function w/Text and Year | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Linear Mode
