function for finding repeats in a column...

Trying to find all repeat data in a column with about 200 rows...

There are two ways I think this could be done, and I need your help. First, if the data was in A, then in B, it would check to see if the corresponding A row has already been used in the whole column.

ex. A B
data repeat?
0 yes
0 yes
2 no
0 yes

The second way I was thinking, and might not be possible, would be if I build in the function straight to A, so that if the data repeats somewhere already in A, then it would bold it or () it or something.

ex. A
data (repeat data)
(0)
(0)
2
(0)

I don't know, this is very confusing I know, but any help would be greatly appreciated.

I would suggest the use of Conditional Formatting.

Select Column A.
Select Conditional Formatting from the Format Menu
Change "Cell Value Is" to "Formula Is"
Enter the formula: =COUNTIF(A:A,A1)>1
Set your format
Click OK

HTH,
Elkar

"killertofu" wrote:

>
> Trying to find all repeat data in a column with about 200 rows...
>
> There are two ways I think this could be done, and I need your help.
> First, if the data was in A, then in B, it would check to see if the
> corresponding A row has already been used in the whole column.
>
> ex. A B
> _data_ _repeat?__
> 0 yes
> 0 yes
> 2 no
> 0 yes
>
> The second way I was thinking, and might not be possible, would be if I
> build in the function straight to A, so that if the data repeats
> somewhere already in A, then it would bold it or () it or something.
>
> ex. A
> data *(repeat data)*
> *(0)*
> *(0)*
> 2
> *(0)*
>
> I don't know, this is very confusing I know, but any help would be
> greatly appreciated.
>
>
> --
> killertofu
> ------------------------------------------------------------------------
> killertofu's Profile: http://www.excelforum.com/member.php...o&userid=31024
> View this thread: http://www.excelforum.com/showthread...hreadid=515016
>
>

thanks, but that didn't work...

I came up with this, see if you guys can work off of this and make something better...

In column b, the cells have the following format, (starting in row 2)

=IF(COUNTIF(A:A,A2)>1,MATCH(A2,A:A,0),"")

This returns nothing if A doesnt repeat, but if it does, it returns the position of the first matching one.