Filling in blanks in Column B with Duplicates in Column A

[TitoBurrito]

Hello Excel Masters.

I am trying to write a formula that will fill in the blank cells for Column B with "Contact 1", "Contact 2", or "Contact 3". Depending on how many duplicates are in Column A.

EX:

174653	Contact 1
174653	Contact 2
175277	Contact 1
175277	Contact 2
178484	Contact 1
178484	Contact 2
178484	Contact 3

Thank you for the help.

 

[awoohaw]

How about ="Contact " & Countif($A$2:A2,A2)

WorkBook1.xlsx
	A	B	C
1	ID	Orig	Solution
2	174653	Contact 1	Contact 1
3	174653	Contact 2	Contact 2
4	175277	Contact 1	Contact 1
5	175277	Contact 2	Contact 2
6	178484	Contact 1	Contact 1
7	178484	Contact 2	Contact 2
8	178484	Contact 3	Contact 3
Sheet3

Cell Formulas
Range	Formula
C2:C8	C2	="Contact " & COUNTIF($A$2:A2,A2)

 

[James006]

Hi,
You can test
="Contact "&COUNTIF($A$2:A2,A2)

 

[TitoBurrito]

Hi,
You can test
="Contact "&COUNTIF($A$2:A2,A2)

This Worked!

Thank you for the quick response!