View Single Post
  #1   Report Post  
Sam
 
Posts: n/a
Default How to print the column # where the max row value is located?

Hello,

I have a row with 100 numbers in it. This row starts in column C and ends
in column CX. I am printing the Maximum number in this row in column B. How
can I print the number of a column that contains this maximum. In other
words, if the maximum occurs in column D, I would like to print 2 in column A.

Thank you very much!