Formula Count Help

[Jeremy]

I have in Column A names that repeat. How do I create a formula in B where
it counts the name only once. Below is an example

Before
A
1 BA
2 CA
3 BA
4 BA
5 CB

After
A B
1 BA BA
2 CA CA
3 BA CB
4 BA
5 CB


Thank you

 

[Eduardo]

Hi,
suppose your list start in cell a2, in B2 enter

=IF(COUNTIF($A$2:A2,A2)=1,A2,"")

copy formula down

 

[Teethless mama]

Take a look Advanced Filter in Help menu

 

[Jeremy]

Thank you for the help. One problem is that it is putting rows inbetween the
next name in b. It is like the example below.
B
1 BA
2 CA
3
4
5 CB