Highlight and delete duplicate

[Bad-Yeti]

Hi there,

I'm new to the group as you've probably guessed, I'm a little stuck and have trawled all over the web seeking an answer to this problem, to now i've found nothing, I thought you guys may be able to help.

Say I have the following in excel:

Column 1 I Column 2 I Column 3
I I
One I Number I
A I Letter I
One I Number I
A I Letter I
One I Number I

Is there a way to make Excel say "okay there are three One's which are numbers S i'm going to delete 2 of them and them put 3 in Column 3, there's also 2 A's so I'll do the same leaving:"

Column 1 I Column 2 I Column 3
I I
One I Number I 3
A I Letter I 2

Any help that could be offered would be really appreciated.

Many thanks

Erm, it keeps taking my spaces out so it doesn't look more spreadsheety.

[Bad-Yeti]

As I messed up the example in the previous post here is a picture:
\1

As you can see Part number 00-10-009 is up there 7 times, can I get Excel to delete 6 of the lines and put a 7 in column c?

[BigBas]

I created a file with some dummy data with a format similar to yours that I believe does the trick. There are a few steps to make it work.

1. Column C contains a formula that checks if column A is a duplicate or the first occurence. This column can be hidden to clean up the file.
2. Column D contains a formula that counts the number of each part number.
3. Use a macro to delete all of the deplicate entries.

See the file below for more details.

[Bad-Yeti]

Sir, you are a star.

I have no idea how you created that (probably black magic and bits of old bat or something) but it worked a charm.

Thank you ever so much for taking the time.

[BigBas]

Unfortunately, I'm not skilled in the art of black magic. If there is anything specifically that you would like details about, just ask, and either I or someone else on the forum will walk you through it.

Glad I could help.