Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlite Duplicates in 2 Columns (Conditional Formating)
Hi,
I have 2 columns of data. Both Columns can contain duplicates How can I find duplicates in both columns. A B 1 Car Toy 2 Ball Toy 3 Bed Bar 4 Car Toy 5 Ball Bar A1, B1, A4 & B4 should be hi-lited with Conditional Formating Thanks for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlite Duplicates in 2 Columns (Conditional Formating)
Hi,
take a look at CPearson web http://www.cpearson.com/excel/Duplicates.aspx if this helps please click yes, thanks "Mike 215" wrote: Hi, I have 2 columns of data. Both Columns can contain duplicates How can I find duplicates in both columns. A B 1 Car Toy 2 Ball Toy 3 Bed Bar 4 Car Toy 5 Ball Bar A1, B1, A4 & B4 should be hi-lited with Conditional Formating Thanks for your help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlite Duplicates in 2 Columns (Conditional Formating)
On Aug 14, 12:00*pm, Eduardo
wrote: Hi, take a look at CPearson web http://www.cpearson.com/excel/Duplicates.aspx if this helps please click yes, thanks "Mike 215" wrote: Hi, I have 2 columns of data. Both Columns can contain duplicates How can I find duplicates in both columns. * * * * A * * * *B 1 * * Car * * Toy 2 * * Ball * * Toy 3 * * Bed * * Bar 4 * * Car * * Toy 5 * * Ball * * Bar A1, B1, A4 & B4 should be hi-lited with Conditional Formating Thanks for your help.- Hide quoted text - - Show quoted text - Eduardo, thanks for responding so quickly. I started looking in cpearson.com/excel/Duplicates, but was unable to make versions of his formulas work to hilight both columns if both are duplicated. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlite Duplicates in 2 Columns (Conditional Formating)
It isn't clear whether you want to highlight duplicates within a
column (ignoring values in the other column) or look for duplicates across both columns. Moreover, why are A2 and A5 not considered duplicates, since both contain "Ball". Similarly, all the entries in column B are duplicates of one another, so the all the entries should be highlighted. Provide more accurate details. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Fri, 14 Aug 2009 09:13:48 -0700 (PDT), Mike 215 wrote: Hi, I have 2 columns of data. Both Columns can contain duplicates How can I find duplicates in both columns. A B 1 Car Toy 2 Ball Toy 3 Bed Bar 4 Car Toy 5 Ball Bar A1, B1, A4 & B4 should be hi-lited with Conditional Formating Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating comparing the two columns | Excel Discussion (Misc queries) | |||
Conditional formating for data in 2 columns | Excel Worksheet Functions | |||
How can I highlite an entire row using conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formating: Compare two columns with Inserted lines | Excel Worksheet Functions | |||
conditional formating of group of columns and rows | Excel Worksheet Functions |