How to retrieve a top/bottom three from a Dbase?
 

Dear aLL,

I'm looking for a function in Excel to retrieve a top / bottom three from a
list. Pretty much like the MAX(..) function, but then for three values i.s.o.
one.

Could anyone please help me with this?

Thanks,

Mark

=LARGE(A2:A100,1)
=LARGE(A2:A100,2)
=LARGE(A2:A100,3)

--
HTH

Bob Phillips

"Mark" wrote in message
...
Dear aLL,

I'm looking for a function in Excel to retrieve a top / bottom three from
a
list. Pretty much like the MAX(..) function, but then for three values
i.s.o.
one.

Could anyone please help me with this?

Thanks,

Mark