how to list unique numbers sorted descending

[raghuram.star]

can you please help me get the list of unique numbers from a list sorted in descending order

I have below array formula, this is taking too long to refresh the list, as i have almost 15000 rows source data and the below formula is used 53 to get to 53 from the list

=IFERROR(INDEX($A$1:$A$15000, MATCH(MIN(IF(COUNTIF($B$1:B2, $A$1:$A$15000)=0, 1, MAX((COUNTIF($A$1:$A$15000, ">"&$A$1:$A$15000)+1)*2))*(COUNTIF($A$1:$A$15000, ">"&$A$1:$A$15000)+1)), COUNTIF($A$1:$A$15000, ">"&$A$1:$A$15000)+1, 0)),"")

I have 15000 rows of data in Column A - from A1 to A15000
Formula in Column B - from Cell B2

Any help in getting the same result faster will be a great help.

Thanks in advance

 

[Michael M]

could you not just use Data>>Advanced filter>>unique records only

 

[XOR LX]

Hi.

If you insist upon a formula solution, then, since you say that the values in column A are numbers, I don't see why you are using a COUNTIF construction.

Simply:

=LARGE(IF(FREQUENCY(A$1:A$15000,A$1:A$15000),A$1:A$15000),ROWS($1:1))

and copied down will suffice, though of course this assumes that every single cell within the range A1:A15000 contains a number (you don't mention blanks, so I assume that there are none within your range).

Regards

 

[raghuram.star]

=LARGE(IF(FREQUENCY(A$1:A$15000,A$1:A$15000),A$1:A$15000),ROWS($1:1))

this did the trick, this is way faster and it saved atleast 10 seconds for each refresh
thank you so much for the help

 

[XOR LX]

You're welcome!