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...