Using SORT function inside MATCH function does not work

New 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:

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 (New Contributor)
Sorry to bother everyone.
The problem is the last parameter in sort function. When I change the function to this:
the problem is solved..