Excel Formula Required

[hrayani]

Hello Friends,

Here is a sample data which will be not more than 5 rows

Col A Col B

PO # UNIT
316543 Sets
316546 Pcs
316547 Sets
316548 Pairs
316549 Dozens


The formula should sort values in Col A based on Units in Col B
Formula should look first at Sets than Pairs than Pcs than Dozens
If there are more than one PO having the same unit like in above sample data than
formula should look at the smallest value first than the 2nd smallest and so on


If any PO does not have Sets as unit than formula should look first at Pairs than Pcs than Dozens
If any PO does not have Pairs as unit than formula should look first at Sets than Pcs than Dozens



Hence answer should be

PO #
316543 Sets
316547 Sets
316548 Pairs
316546 Pcs
316549 Dozens


Any help would be appreciated

Regards,

Humayun

 

[t0azt]

Would a pivot table work for you? I think it might be the most practical solution.

 

[hrayani]

No dear. The sheet contains loads of other things too.