CODEWITHSUNDEEP
excelsortinguniquerank
Raspi Surya
Raspi Surya

Reputation: 315

sorting in Excel with Rank Function in Group

case rank ascending 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)? the flow is go through in the group, find the min number in the rank within the group and put into the reverse order.

Upvotes: 0

Views: 347

Answers (1)

pnuts
pnuts

Reputation: 59485

Assuming Group is in A1, series fill ColumnC from 1 to 10 then sort that column from where the second Group starts (C4:C10) by A A to Z and B Smallest to Largest.

Upvotes: 0

Related Questions