Hi,
I have a column of numbers on which I'm using the large function. I basically need the top ten numbers in the column. Then for each of the top 10 numbers (say sales numbers), I'm trying to get excel to show the sales persons name, but the name is to the left of the row with sales number. So I am trying to figure out a way to have excel give me the row # in which the largest value resides. Then I plan to use the offset function from the row & the column to return the salespersons name. Any suggestions?
Tx,
I have a column of numbers on which I'm using the large function. I basically need the top ten numbers in the column. Then for each of the top 10 numbers (say sales numbers), I'm trying to get excel to show the sales persons name, but the name is to the left of the row with sales number. So I am trying to figure out a way to have excel give me the row # in which the largest value resides. Then I plan to use the offset function from the row & the column to return the salespersons name. Any suggestions?
Tx,