Sort column with row numbers

[Raffe]

Hello,

I need your help. I have a column with values that I would like to sort. I would like to have the row number for each sorted values like:

Ex
===

5
3
6
4

And the output I would like to a have is:

3 2
4 4
5 1
6 3

Are there any quick way to do this? I got 60000 values I would like to sort ...


Cheers
Raffe

[AlKey]

Enter formula in B1 and copy down

Please Login or Register  to view this content.

then in C1 and copy down

Please Login or Register  to view this content.

v	A	B	C
1	5	3	2
2	3	4	4
3	6	5	1
4	4	6	3

[jaslake]

Hi Raffe

Try something like this...

Please Login or Register  to view this content.

[Raffe]

Thank you very much! Very kind people here!