Sort Ascending by Rank in Excel

[abadilala]

https://imgur.com/tCXlMF1

Hi, can anyone help me how to sort data in excel with help of rank function?
I have made until the rank function, however, I dont have any idea how to get the expected result in column F.

Please help!

 

[mole999]

RANK won't give you the same value for different numbers, so how did you get the values the first time

 

[MARK858]

Based on your image and if your product codes start in D4...
Make F3 blank, put the formula

=IF(LEFT(D4,1)<>LEFT(D3,1),F3+1,F3)

in F4 and copy down. Copy and paste column F as values, select the whole range and sort by column F then column E.

Columns D & E should now be in the order requested.

 

[abadilala]

HI Mark,
thank you for replying. However, what I want is to create formula in F column. Not with Excel build in function.