View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DKY
 
Posts: n/a
Default column number of the answer to MIN


How do I grab the column number to this function
MIN(C2:F2)

Actually, what I'm looking to do is display the header of whatever the
answer to the above function is. All the headers are in row 1. So in
essence, if the min is in column D then it will display the data in D1.


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=524315