Find Duplicates
 

In a column is there a way to find duplicate values, like the exact same
names ?

Find Duplicates
 

http://www.cpearson.com/excel/Duplicates.aspx
--
Gary''s Student - gsnu200856

Find Duplicates
 

Hi,

In 2007 - highlight the column and choose Home, Conditional Formatting,
Highlight Cell Rules, Highlight Duplicates

In 2003 - use a formula approach or condtional formatting:

1. Select the cells you want to format
2. Choose Format, Conditional Formatting
3. Choose Formula is from the first drop down
4. In the second box enter the formula:
=COUNTIF(A$1:A$100,A1)1
5. Click the Format button
6. Choose a color on the Patterns tab (or any available option)
7. Click OK twice.

To make this case sensitive replace the above formula with
=SUMPRODUCT(--EXACT(A$1:A$100,A1))1

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"rap43" wrote:

In a column is there a way to find duplicate values, like the exact same
names ?

Find Duplicates
 

Thanks Shane I had findly found that and it works great.

"Shane Devenshire" wrote:

Hi,

In 2007 - highlight the column and choose Home, Conditional Formatting,
Highlight Cell Rules, Highlight Duplicates

In 2003 - use a formula approach or condtional formatting:

1. Select the cells you want to format
2. Choose Format, Conditional Formatting
3. Choose Formula is from the first drop down
4. In the second box enter the formula:
=COUNTIF(A$1:A$100,A1)1
5. Click the Format button
6. Choose a color on the Patterns tab (or any available option)
7. Click OK twice.

To make this case sensitive replace the above formula with
=SUMPRODUCT(--EXACT(A$1:A$100,A1))1

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"rap43" wrote:

In a column is there a way to find duplicate values, like the exact same
names ?

Find Duplicates
 

Shane,
Thank you!! it worked great!!!

"Shane Devenshire" wrote:

Hi,

In 2007 - highlight the column and choose Home, Conditional Formatting,
Highlight Cell Rules, Highlight Duplicates

In 2003 - use a formula approach or condtional formatting:

1. Select the cells you want to format
2. Choose Format, Conditional Formatting
3. Choose Formula is from the first drop down
4. In the second box enter the formula:
=COUNTIF(A$1:A$100,A1)1
5. Click the Format button
6. Choose a color on the Patterns tab (or any available option)
7. Click OK twice.

To make this case sensitive replace the above formula with
=SUMPRODUCT(--EXACT(A$1:A$100,A1))1

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"rap43" wrote:

In a column is there a way to find duplicate values, like the exact same
names ?