T
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?
lowest, and sometimes it shows one item twice. Can anyone
tell me why?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Michael
Hi Troy
Instead of using LARGE, why don't you highlight your
column and then do Data/Sort/Descending
Regards
Michael
Instead of using LARGE, why don't you highlight your
column and then do Data/Sort/Descending
Regards
Michael
T
Troy
I have to use VLOOKUP to return a different value in
several different Cells.
several different Cells.
V
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).
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).
B
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)
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)
T
Troy
The way I had the formula set up, I only had to add
another `IF' statement. Thanks.
another `IF' statement. Thanks.