Sorting Unique records

[tommy j]

Column A contains list of order ID numbers. One order may
generate 5 rows if there are 5 items in the order. How can
I sort for uniqueness (??)based only on column but yet
expand the selection?

 

[Debra Dalgleish]

Include an order ID number on each row, and add a LineID in column B, e.g.:

OrderID LineID Item Qty Price Total
1123 1 Pencil 7 81 567
1123 2 Pen 5 71 355
1124 1 Paper 3 86 258

Then, you can apply an AutoFilter (Data>Filter>AutoFilter). In column B,
filter for rows that contain a 1, and you'll see only the first row of
each order.