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
buffyslay wrote:
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
|