find and match the max

[buffyslay]

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 follo

 

[Govind]

Hi,

For finding out the first & second largest amount use

= LARGE(RANGE, 1)

and

= LARGE(RANGE,2)

To find out the user id, give me the way the data is organised.

REGARDS

Govind