Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Retrieving data from a corresponding row from a different column
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? -- fluci ------------------------------------------------------------------------ fluci's Profile: http://www.excelforum.com/member.php...o&userid=25896 View this thread: http://www.excelforum.com/showthread...hreadid=479325 |
#2
|
|||
|
|||
Retrieving data from a corresponding row from a different column
INDEX(Range_with_names,MATCH(MAX(Money_range),Mone y_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) "fluci" wrote in message ... 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? -- fluci ------------------------------------------------------------------------ fluci's Profile: http://www.excelforum.com/member.php...o&userid=25896 View this thread: http://www.excelforum.com/showthread...hreadid=479325 |
#3
|
|||
|
|||
Retrieving data from a corresponding row from a different column
um... Not too sure I understand that And yes, there is only one max -- fluci ------------------------------------------------------------------------ fluci's Profile: http://www.excelforum.com/member.php...o&userid=25896 View this thread: http://www.excelforum.com/showthread...hreadid=479325 |
#4
|
|||
|
|||
Retrieving data from a corresponding row from a different column
anyone please? -- fluci ------------------------------------------------------------------------ fluci's Profile: http://www.excelforum.com/member.php...o&userid=25896 View this thread: http://www.excelforum.com/showthread...hreadid=479325 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional format based on data from another column | Excel Discussion (Misc queries) | |||
2 Column Data lookup | Excel Discussion (Misc queries) | |||
Combining workbooks with some variable field names | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
filling a forumla down a column from data across a row | Excel Worksheet Functions |