Select the columns then DataFilterAdvanced 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

On Tue, 2 Jan 2007 15:50:00 -0800, Ben wrote:

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