Using formula to sort elements in a sheet to another

[vaishaks89]

Hi All,

Good afternoon to you all.

I am here with a query today. Its about regarding sorting.

Right now, I have an excel file with a sheet "Unsorted List". This Sheet contains
Rank and Customer Names. Its a sheet that will contain customer names ranked (using a rank function based on revenue).

What I want to do is, I want to transfer the respective Rank and Customer Names to another sheet "Sorted List" except that I want them to be sorted in ascending order.

So, in my unsorted list, the first value will be
Rank 215 Customer 20 Cube logistics Ltd
In my sorted list this value should be
Rank 1 Customer E&Y


I am also attaching the file with the post.

It will be a great help if I could get the solution, as I am really running in circles with this things.

Thank u guys
Regards
Vaishak S

 

[Naresh Yadav]

Dear Vaishak89

pls find the attached file and check if it is correct for you..

regards
Naresh

 

[Naresh Yadav]

here is the second option if you don't want to get the duplicate value of RANK in your sorted list and than do the vlookup to get your sorted Member

=IFERROR(SMALL(IF(FREQUENCY('Unsorted List'!$A$2:$A$241,'Unsorted List'!$A$2:$A$241)>0,'Unsorted List'!$A$2:$A$241),ROW('Unsorted List'!A218)),"")

 

[vaishaks89]

Actually, I want those duplicate ranks and the associated customer names.
Like in that sheet Rank 215 will be repeating atleast 10-15 times.
So, I will have
Rank Customer
215 20 cube Logistics
215 XYZ
215 ABC

So, in the sorted sheet, I would want to see all of them. Just that, I want the rank numbers in sorted order along with their curresponding customers.