Thread: Function to return # of column with min value in selected rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mr_espresso
 
Posts: n/a
Default Function to return # of column with min value in selected rows
Hi folks. For the sample data below, columns A €“ C contain survey response
data: 3, 6 and 9. I'm looking for advice on writing a function for column D
that would look at columns A €“ C and return the # of the column containing
the min value (e.g. A in this example). Thank you in advance!

A B C D
3 6 9 A
Reply With QuoteReply With Quote