Hi "bj"

Thanks a ton.

I am still trying. Hopes it works.

gkb

"bj" wrote:

try
=LARGE($A1:$C1,column()-3)

"gkb" wrote:

Hi,

Thank you.
I did try this formula... and got the desired result. But I am not able to
paste this formual in all cells. There is some "array" formula working here...

=LARGE($A$1:$C$1,1)

Hope you will get me a solution to this also.

Thank you once again

gkb

"Gary''s Student" wrote:

Use the LARGE() function.


--
Gary's Student


"gkb" wrote:

Hi

Can someone help me to find out and place the highest, second highest, third
highest and so on in group of numbers in a sheet?

For example:

QUESTION:
A B C D E F
1004 1004 1004
1518 1517 797
1332 1320 1500
1337 1337 1004
1337 1337 1000
1940 560 1560

I need to find out which is highest, second highest and third highest from
A,B & C and the D, E & F columns should display Highest, Second Highest,
Third Highest accordingly. Where the numbers are equal, i need a display
Equal(AB) or Equal(BC) or Equal (ABC) as the case depends.

I might be overthinking on this, but I am just not getting the right formula.

If someone could please help on this... please

GKB