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;T...
- 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..
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..
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..