sorting in Excel with Rank Function in Group

[abadilala]

hi, I would like to discuss on how to get sorting ascending formula from this case. Expected result is as shown in the picture in blue column. The only reference that can be used is Rank column (Yellow) and Group column (white).
Any idea how to get the rank unique expected column (blue)? do you have idea how to do this using excel formula?
https://imgur.com/lrkHPSb

 

[jimrward]

Is this not similar to the question you asked yesterday

Would it not be better to keep as one thread