Thread: Column Numbers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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