Identify and Label Duplicates

[SOLTEC]

Thank you in advance for any and all assistance. It is a greatly appreciated.

I need a formula or function to find and label duplicates.

Here is sample data

Column A Column B Column C

1 Replacement Boot Laces 1
2 Replacement Boot Laces 1
3 Blousing Garters 2
4 Blousing Garters 2
5 Blousing Garters 3
6 Blousing Garters 3
7 GI Extreme Cold Weather Bunny Boots 4
8 GI Extreme Cold Weather Bunny Boots 4
9 GI Extreme Cold Weather Bunny Boots 4
10 GI Extreme Cold Weather Bunny Boots 4
11 GI Extreme Cold Weather Bunny Boots 4
12 GI Extreme Cold Weather Bunny Boots 4
13 Nylon Commando Wallet 5
14 Nylon Commando Wallet 5
15 Nylon Commando Wallet 5
16 Nylon Commando Wallet 5
17 Nylon Commando Wallet 5
18 Nylon Commando Wallet 5
19 Nylon Commando Wallet 5
20 Pepper Sprays Gel Sabre Red 6
21 Fire Master Fog Pepper Spray 7
22 Pepper Sprays Gel Sabre Red 8
23 Pepper Sprays Gel Sabre Red 8
24 Pepper Sprays Gel Sabre Red 8
25 Pepper Sprays Gel Sabre Red 8
26 Key Chain Pepper Spray 9

I have over 10,000 items to go through and doing them one at a time is tedious and frustrating. I would like to do this programmatically.

Please HELP and Thank you.

 

[SteveO59L]

concatenate your list (=a1&b1&c1) and fill down col d (col D can be hidden if need be)

in e1

=COUNTIF($D$1:$D$26,D1)

will return the count of items

 

[SOLTEC]

I think I wasn't clear in my post, my apologies.

The first two columns A & B are my data. I need to generate column C

 

[SteveO59L]

and how do you arrive at this result?

3 Blousing Garters 2
4 Blousing Garters 2
5 Blousing Garters 3
6 Blousing Garters 3

 

[SOLTEC]

Steve

A match for the string, I guess a Boolean when comparing.

Blousing Garters should all be number 2, my mistake. I shouldn't be posting in the AM with little sleep

The count with the Name.

Name being the focus of the solution.

Replacement Boot Laces
Replacement Boot Laces are a match. Use the unique number that is first. Say for example, Replacement Boot Laces is item 1, then so would the second Replacement Boot Laces. But if no match, continue sequentially with numbering.

that's where the third column comes in.

Here is a link to the spreadsheet https://app.box.com/s/cio68lack13viqqyvvlrwqt2ysbfi7qv

 

[SOLTEC]

Steve,

I believe the term is a group ID for duplicates.

Group 1 Replacement Boot Laces x 2
Group 2 Blousing Garters x 4
Group 3 GI Extreme Cold Weather Bunny Boots x 6
Anything not in a group, just sequential numbers.

 

[SOLTEC]

Steve,

I believe the term is a group ID for duplicates.

Group 1 Replacement Boot Laces x 2
Group 2 Blousing Garters x 4
Group 3 GI Extreme Cold Weather Bunny Boots x 6
Anything not in a group, just sequential numbers.

Here is a link to what I am doing manually: https://app.box.com/s/4fhd7as8g6ppxu9qbok6zr91ialn0ev0

 

[SOLTEC]

New more extensive xlxs file on box.com

https://app.box.com/s/u6veh8zkfmq3z43wa7ddcbxpmg95pxi6