Forum Discussion
Solved
Using SORT function inside MATCH function does not work
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..
- 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..
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)
- 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..
