software

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: www.excelforum.com/member.php...oamp;userid=31024
View this thread: www.excelforum.com/showthread...hreadid=515016I would suggest the use of Conditional Formatting.

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

HTH,
Elkar

quot;killertofuquot; wrote:

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


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)gt;1,MATCH(A2,A:A,0),quot;quot;)

This returns nothing if A doesnt repeat, but if it does, it returns the
position of the first matching one.--
killertofu
------------------------------------------------------------------------
killertofu's Profile: www.excelforum.com/member.php...oamp;userid=31024
View this thread: www.excelforum.com/showthread...hreadid=515016