ok - what i am trying to do here is a basic auction page.

using the lot number

and find the highest amount and second highest amount and the user id?

any ideas?
table to follow


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