PDA

View Full Version : Find row number of maximum value found in a given column?



Recneps
04-21-2015, 04:09 PM
I need to create a function that will return the row number the maximum value in a column. I'm thinking I could correspond each column to a number (1=A, 2=B, etc.); any ideas on how to do this?

mancubus
04-21-2015, 11:58 PM
this formula will return the order (= row number) of max value in column B

=MATCH(MAX(B:B),B:B,0)