kind of new to excel, need help finding values

  • Thread starter Thread starter evann
  • Start date Start date
E

evann

ok i've got statistics of 100 users, A column is their username..
column-G column are different stats for each user. How can I find th
Max of say column B, and get their name from column A, then displa
them in a cell (or a seperate cell for the max,and their name). I kno
how to get Max, but not how to get the corrisponding name. Thanks al
 
Hi
try in
H1
=MAX(B1:B100)
I1:
=INDEX(A1:A100,MATCH(H1,B1:B100,0))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Max(s5:s69)...help 15
Excel Average dates help 0
Need VLOOKUP to Work Two Ways 0
Returning Sorted Values 3
Is there a way to find the max in a set of data that meet a certaincriteria w/o using an array formu 7
Referencing text of a cell next to the greatest value in column 1
Cell value using Max 3
IF column contains certain text return value of corresponding row 7

Back
Top