LARGE

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?
 
M

Michael

Hi Troy
Instead of using LARGE, why don't you highlight your
column and then do Data/Sort/Descending
Regards
Michael
 
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).
 
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)
 
T

Troy

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using an IF or AND function to get next largest value in list 1
Merging from an Excel file with graphics 1
Microsoft 365 Activations, Users or Devices? 0
Possible to Combine reports to's to a single box? 0
"Fields Nested Too Deeply" Error in Simple Word Document 5
Scroll does not show preview 0
Return Column Header from an Index/array, finding Large with a userinput date 0
Q on LARGE function 1

Top