LARGE

[Troy]

I am using "LARGE" to list a column from largest to
lowest, and sometimes it shows one item twice. Can anyone
tell me why?

 

[Michael]

Hi Troy
Instead of using LARGE, why don't you highlight your
column and then do Data/Sort/Descending
Regards
Michael

 

[Troy]

I have to use VLOOKUP to return a different value in
several different Cells.

 

[Vasant Nanavati]

If the item appears twice in your source list, it will appear twice in your
LARGE list. If you want only the unique items listed, you would have to use
a fairly complex formula (which I don't remember offhand).

 

[Bob Phillips]

Hi Vasant,

I think (hope?) you are referring to the RANK+COUNTIF formula

=RANK(A1,$A$1:$A$10)+COUNTIF($A$1:$A1,A1)-1

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Troy]

The way I had the formula set up, I only had to add
another `IF' statement. Thanks.