I found a posting for the problem I am trying to solve but can't seem to get it to work.. maybe it is the edition of excel that I am using (2010)??

http://www.excelforum.com/excel-gene...uplicates.html

I need to find the max value form duplicate values (in rows) and have another columns value returned for the row that contains the max value.. I have read that a pivot table will allow one to do this but I have ~64K rows of data. If pivot tables can be used in this case can someone explain, to an excel novice, how to perform the task?

Here is an example:
max lookup example.xlsx

Thanks in advance for any help.