SOLVED

Using SORT function inside MATCH function does not work

Copper Contributor

I have a column with various recurring texts.

I want RANK each text by ascending order.

In order to do that I've written a function like this:
=MATCH(A2;SORT(UNIQUE($A$2:$A$2579;FALSE;FALSE);1;1;TRUE);0)

The SORT function doesn't seem to be working. Whether it is there or not, the resulting numbering is done according to non-sorted values.

How can I fix this?

Thank you for your help..

2 Replies
Please inform us about your Excel Version and Operating System, is advantage for all. At the same time if i can recommend, insert a file (without sensible dates) and explain you problem on basis this file. Thank you for your understanding and patience Nikolino I know I don't know anything (Socrates)
best response confirmed by oncelturer (Copper Contributor)
Solution
Sorry to bother everyone.
The problem is the last parameter in sort function. When I change the function to this:
=MATCH(A2;SORT(UNIQUE($A$2:$A$2579;FALSE;FALSE);1;1;FALSE);0)
the problem is solved..
1 best response

Accepted Solutions
best response confirmed by oncelturer (Copper Contributor)
Solution
Sorry to bother everyone.
The problem is the last parameter in sort function. When I change the function to this:
=MATCH(A2;SORT(UNIQUE($A$2:$A$2579;FALSE;FALSE);1;1;FALSE);0)
the problem is solved..

View solution in original post