Macro to remove duplicates

[Alex O]

Need help with a macro that will identify duplicates in C & E and keep first instance of duplicate. So my example below would look like:
24/7 Shield Security & More 6 1441.82
24/7 Shield Security & More 6 1231.98

Example:
24/7 Shield Security & More 6 1441.82
24/7 Shield Security & More 6 1231.98
24/7 Shield Security & More 6 1231.98

Any help would be appreciated.

[Rayman]

Need help with a macro that will identify duplicates in C & E and keep first instance of duplicate. So my example below would look like:
24/7 Shield Security & More 6 1441.82
24/7 Shield Security & More 6 1231.98

Example:
24/7 Shield Security & More 6 1441.82
24/7 Shield Security & More 6 1231.98
24/7 Shield Security & More 6 1231.98

Any help would be appreciated.

In your example its not clear what are record for column C and E . Please details

[Alex O]

C D E
24/7 Shield Security & More 6 1441.82
24/7 Shield Security & More 6 1231.98
24/7 Shield Security & More 6 1231.98

Sorry

[JohnnyBravo]

C D E
24/7 Shield Security & More 6 1441.82
24/7 Shield Security & More 6 1231.98
24/7 Shield Security & More 6 1231.98

That is about as clear as mud. WHAT is contained in C1,
WHAT is contained in D1, etc.

Just saying "24/7 Shield Security & More 6 1441.82" doesn't tell us anything. That entire string could be in C1 or are you telling us that just a portion of that (e.g. 24/7 Shield Security & More 6) is contained in C1

Excel 2007/2010 already has a duplicate removal feature built in. Search for it in the Data tab. If you're using a different version - then you should also include that in your post so that people can help you.

[Rayman]

C D E
24/7 Shield Security & More 6 1441.82
24/7 Shield Security & More 6 1231.98

24/7 Shield Security & More 6 1231.98

Sorry




Well, if i understandand:

C= 24/7
D=Shield Security & More 6
E=1231.98

Is this correct?

[Alex O]

C= 24/7 Shield Security & More
D=6
E=1231.98

[Rayman]

Try the attached file

[Alex O]

Perfecto...Thanks!!