find and match the max

B

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
 
G

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
 
Top