Retrieving data from a corresponding row from a different column

  • Thread starter Thread starter fluci
  • Start date Start date
F

fluci

Hello everyone. I have a dilemna and I need some help.

I have values in rows 1-100, and columns A-J
I need to put, into A2, the name of the person who has donated the most
money to my charity fund.
What I currently need to do is have a fluctuating chart that constantly
changes as I change the data.

What I am looking for, is somthing like this
Find the MAX(G:G)
From that value, determine the row which it is in.
From that specific row, retrieve the value from column A in there

I am trying to do something like...
A3 Formula: Column A of ROW(MAX(G:G))
Of course we all know that doesnt work, which is why I am here
Any help?
 
INDEX(Range_with_names,MATCH(MAX(Money_range),Money_Range,0))

what about a tie, the above will return the first occurrence of max, not a
second or third o=if there are
more than one

--
Regards,

Peo Sjoblom

(No private emails please)
 

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

VBA - retrieve data on last create named range from previous inserted named range 0
Excel Help to copy information from one row at a time to another sheet 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Max Length in a row 1
Return MAX value from column B and Name from column A 2
I am trying to write a macro using If...Then 1
Copy paste data from a column to a row 0
Retrieving data from a table 4

Back
Top