Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
comparing columns
how do i compare mulitple columns, returning lowest value, ignoring blank
cells. Additionally, how do identify which column supplied that information |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
comparing columns
Hi
Try the following 2 array formulae {=MIN(IF(A1:M10,A1:M1))} to find the lowest non-zero value {=MATCH(MIN(IF(A1:M10,A1:M1)),A1:M1)} to return the column number where the lowest value occurs. Use Ctrl+Shift+Enter (CSE) to commit on Edit the formula rather than just Enter. Do not type the curly braces { } yourself, Excel will enter them when you use CSE Change range to suit -- Regards Roger Govier "JRM" wrote in message ... how do i compare mulitple columns, returning lowest value, ignoring blank cells. Additionally, how do identify which column supplied that information |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comparing 2 columns | Excel Discussion (Misc queries) | |||
Comparing columns | Excel Worksheet Functions | |||
comparing columns | Excel Discussion (Misc queries) | |||
Comparing two columns of information with 2 new columns of informa | Excel Discussion (Misc queries) | |||
comparing two columns? | Excel Discussion (Misc queries) |