Column Numbers
Hi,
=MATCH(MIN(A1:D1),A1:D1,0)
Mike
"Doug Terry" wrote:
How do I get the column number of the minimum value in a row?
Example:
A B C D
4 9 2.5 7
How do I get the column number of 3? I'd like to use this value in a lookup
function in another location.
Thanks,
--
Doug Terry
|