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.


--
killertofu
------------------------------------------------------------------------
killertofu's Profile: http://www.excelforum.com/member.php...o&userid=31024
View this thread: http://www.excelforum.com/showthread...hreadid=515016

function for finding repeats in a column...
 

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

function for finding repeats in a column...
 

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.


--
killertofu
------------------------------------------------------------------------
killertofu's Profile: http://www.excelforum.com/member.php...o&userid=31024
View this thread: http://www.excelforum.com/showthread...hreadid=515016