comparing columns
 

how do i compare mulitple columns, returning lowest value, ignoring blank
cells.

Additionally, how do identify which column supplied that information

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