Ok, If I copy that one column that works beautifully, however. If I highlight
the column within the 5000row 21 column sheet and try filter in place it
changes nothing, I'm guessing this is because its looking across at the other
columns (which will all be different) and as they're all therefore unique
it's not removing any of them.

I need it to get rid of all duplicate entries of the order number in column
A regardless of the data in the other columns, and yes I need the data in the
other columns on the row that's left to remain intact.



"Pete_UK" wrote:

You can copy your order numbers (with heading) to another sheet. Then
highlight the data and heading and click on Data | Filter | Advanced
filter and in the pop-up click on Unique records only and also Filter
to another location - specify C1. Click OK and you will have your
unique list in column C - you can delete columns A and B if you want
to.

Hope this helps.

Pete

On Sep 17, 2:14 pm, JBW wrote:
I have a 5000+ number list within a spreadsheet made up of 6 digit order
numbers, if an order numbers 'order' contained multiple items then the number
appears x times in the list, once per item.

I want to pivot the data, but need to extract a list of order numbers with
their relevant data from the other columns, at the moment the only way (to
me) seems to be to sort by order number and manually delete the duplicate
occurences. example of data below, actual is 20+ columns wide

246335 14/06/2007 F170656
246341 14/06/2007 F170925
246526 15/06/2007 F170770
246551 15/06/2007 F170785
246620 18/06/2007 F170993
246627 18/06/2007 F171022
246628 18/06/2007 F171023
246637 18/06/2007 F170699
246689 18/06/2007 F170785
246690 18/06/2007 F171105
246690 18/06/2007 F171105
246690 18/06/2007 F171105
246690 18/06/2007 F171105
246690 18/06/2007 F171105
246690 18/06/2007 F171105
246690 18/06/2007 F171105
246690 18/06/2007 F171105
246690 18/06/2007 F171105
246690 18/06/2007 F171105
246690 18/06/2007 F171105
246690 18/06/2007 F171105
246690 18/06/2007 F171105
246690 18/06/2007 F171105

ideas?