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

 

[barry houdini]

One way would be to use this formula in B1

=A1

then in B2 copied down as far and more than you need

=IF(ROWS(B$2:B2)>=SUMPRODUCT((A$1:A$1000<>"")/COUNTIF(A$1:A$1000,A$1:A$1000&"")),"",INDEX(A$1:A$1000,MATCH(TRUE,INDEX(ISNA(MATCH(A$1:A$1000,B$1:B1,0)),0),0))