find and match the max
 

i have two tables
and (quick recap - i want to find out the highest bid and the second
highest bid - i haven't thought about if there is more than one high
bid)


Lot Number: Highest Amount Second Highest User
A1
A2
A3
A4
A5
A6
A7
A8
A9
A10
A11
A12
A13
A14



Lot Number Amount User
A1 2.66 User 6
A1 3 User 5
A1 3.56 User 1
A1 3 User 3
A0 3 User 4
A1 1 User 5
A1 2 User 1
A1 3 User 3
A10 2 User 4
A10 3 User 5
A11 2 User 1
A11 3 User 3
A12 2 User 4
A12 3 User 5


--
buffyslay
------------------------------------------------------------------------
buffyslay's Profile: http://www.excelforum.com/member.php...fo&userid=3573
View this thread: http://www.excelforum.com/showthread...hreadid=274473