I don't think Advanced Filter is going to work for this. I want unique
records per each group. Each group is divided by an empty row. ME21N may
show up three times in one group and needs two of them deleted, but ME21N can
be in several other groups only once and it's not to be deleted. So, by
filtering using the "unique records only", I can't see how it can work.
Anyway, as I said, this project is now done--done painfully manually. The
week is ended. I'm going home. Thank you for your input. Connie

"Gord Dibben" wrote:

Connie

You don't need a macro for this.

You can use DataFilterAdvanced Filter to select unique records.

See Debra Dalgleish's site for more info.

http://www.contextures.on.ca/xladvfi....html#FilterUR

If you want a macro, record one while going through the steps.


Gord Dibben Excel MVP


On Fri, 18 Nov 2005 08:35:46 -0800, "Connie Martin"
wrote:

I need another macro! Boy, I wish I knew how to write these wonderful
things! In the sample below I need a macro that will delete the entire rows
where the data is repeated in a given column---that is, that it would delete
the repeat ones, leaving one of them. In this example, in the first set, all
that should be left are two rows which contain ME22N and MR8M in column E.
ME22N is repeated two more times and those rows need to be deleted. If I
could get a macro that would ask for the column to operate in, that would be
great for other spreadsheets where it would not necessarily be column E.

A B C D E
MACLEOL Lynn MacLeod P0040104 ME22N
MACLEOL Lynn MacLeod P0040104 ME22N
MACLEOL Lynn MacLeod P0040104 ME22N
MACLEOL Lynn MacLeod P0040104 MR8M

MACLEOL Lynn MacLeod P0050006 MB0A
MACLEOL Lynn MacLeod P0050006 MB0A
MACLEOL Lynn MacLeod P0050006 MB0A
MACLEOL Lynn MacLeod P0050006 ME21N
MACLEOL Lynn MacLeod P0050006 ME21N
MACLEOL Lynn MacLeod P0050006 ME21N

MACLEOL Lynn MacLeod P0050008 ME21N
MACLEOL Lynn MacLeod P0050008 ME21N
MACLEOL Lynn MacLeod P0050008 ME21N
MACLEOL Lynn MacLeod P0050008 MIGO
MACLEOL Lynn MacLeod P0050008 MIGO
MACLEOL Lynn MacLeod P0050008 MIGO
MACLEOL Lynn MacLeod P0050008 MIGO