| Home |
| Search |
| Today's Posts |
|
#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. |
| 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 | |||
Threaded Mode
