Re: tagging unique items in a list

You say the second set of characters can have different lengths. What about
the first set, the set of 17 characters in your example?
Also, you say you want the unique entries "moved". Not copied but moved?
Otto
"K. Gwynn" <KGwynn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:56A61AB8-70C4-495A-B577-B1C8C68C39BE@xxxxxxxxxxxxxxxx
Yes, I am interested in only finding the entries that are unique. But its
not
always the same number of characters. The second set of characters is
sometimes as many as four characters long. The stuff at the end could be
as
short as 3 characters or as long as 5 extra characters.
Once identified, I need to have the unique entries moved to another column
so I can work just with them.

"Otto Moehrbach" wrote:

Correct me if I'm wrong here, but it appears that you are not interested
in
finding duplicate entries, but only those entries that are duplicate for
the
first specific number of characters. In your examples that's 17
characters.
In other words, not counting what you refer to as the extension. Is that
right?
You would need VBA for that but you don't say what you want done with
entries that are found to be duplicates (for the first 17 characters).
Do
you want duplicates highlighted? Moved? Copied? All the entries that
are
duplicates or do you want to leave one? HTH Otto
"K. Gwynn" <KGwynn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:28750A14-DA8E-4FFD-983D-15593877038D@xxxxxxxxxxxxxxxx
Before posting this message I read through all the posts for finding
and
counting unique entries and tried most of the responses and still have
not
found a solution that works for my situation.

So here goes:

I have a spread*** with 700+ entries. The records I need to sort on
look
like this:
CMMI2_CM_GP2_08_G
CMMI2_CM_GP2_09_P
CMMI2_CM_GP2_09_P
CMMI2_CM_GP2_09_P_PD_PP_H
CMMI2_CM_GP2_10_P_ND_PP_H

In the example above the duplicates are
CMMI2_CM_GP2_09_P
CMMI2_CM_GP2_09_P
CMMI2_CM_GP2_09_P_PD_PP_H

So when I've tried using Advanced Filter, the two that look exactly the
same
are filtered out, but the one with the "PD_PP_H" extension is not.

[No, that extension cannot be filtered out ahead of time and yes, it is
important to the data set].

Now what? Thanks in advance for any suggestions and help.





.