Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Duplicates
In a column is there a way to find duplicate values, like the exact same
names ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Duplicates
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find duplicates | Excel Worksheet Functions | |||
Find duplicates | Excel Discussion (Misc queries) | |||
Find Duplicates | Excel Discussion (Misc queries) | |||
Find Duplicates & Concatenate (cpm) | Excel Discussion (Misc queries) | |||
Find duplicates | Excel Discussion (Misc queries) |