Not sure if this is possible...

[Guest]

Here is what I have.

RANK Sales Order DELIVERY STATION Date COMMENTS
1 62511778 02-Jan-07 SHIPPED 02-Jan-07 STD
1 62511794 02-Jan-07 SHIPPED 02-Jan-07 STD
1 62511795 02-Jan-07 SHIPPED 02-Jan-07 STD
1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD
1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD
1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD
1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD
1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD
1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD
1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD
1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD
1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD
1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD
1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD
1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD
1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD
1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD
1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD
1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD
1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD
1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD

What I want to do is delete all of the sales orders that are identical.
Essentially what I want the list to look like is this.

RANK Sales Order DELIVERY STATION Date COMMENTS
1 62511778 02-Jan-07 SHIPPED 02-Jan-07 STD
1 62511794 02-Jan-07 SHIPPED 02-Jan-07 STD
1 62511795 02-Jan-07 SHIPPED 02-Jan-07 STD
1 62511840 02-Jan-07 SHIPPED 02-Jan-07 STD
1 62511841 02-Jan-07 SHIPPED 02-Jan-07 STD

I know how to "Identify duplicate values in a range" with a specific color,
but I wanted to know if there is anyway to set up a macro or a formula that
will delete an entire row if the sales order matches another. However, I do
need one of those sales orders and it's accompanying info to remain in the
sheet. This list was easy to do by hand, just going through and deleting the
rows with the same sales order, but keeping one, however, genearlly these
lists are hundreds of rows long. I do auto filter for other applications on
the sheets, but it would not be feasable to do that for this. I print these
sheets out, and, I would not want to print a sheet for each individual sales
order. Any Suggestions? Is this possible? I have an excel book but I
cannot find what I am looking for here, maybe I just do not know the correct
name for the action. Thank You in Advance!!

 

[Peo Sjoblom]

Select the table, do data>filter>advanced filter, select unique records
only, click OK Now copy the filtered table somewhere else or do it in
one fell swoop when you apply the filter there is also an option called
"copy t0 another location"



Regards,

Peo Sjoblom

 

[Gord Dibben]

Select the columns then Data>Filter>Advanced Filter

The List Range will be filled by your selection.

In the criteria dialog enter B:B

Checkmark on "Unique records"

Copy to another range or filter in place.


Gord Dibben MS Excel MVP