Jul 28 2021 06:45 AM
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..
Jul 28 2021 06:50 AM
Jul 28 2021 07:00 AM
SolutionJul 28 2021 07:00 AM
Solution