Sorting Unique records

  • Thread starter Thread starter tommy j
  • Start date Start date
T

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?
 
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.
 
Back
Top