Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlighting duplicate entries
Hi
I am hoping someone can help me. I am about to fill a spreadsheet with data and i have a problem. There will be about 8 columns but what i need to do is highlight where there are multiple pairs of data. Not if say column 5 has multiple names but where column 5 has a name and column 8 has a name. I need to highlight any rows there the same two names occur in these cells. I would like this to search automatically as there will be thousands of names. I need to be able to do it comparing columns 5-6, 5-7, 5-8, 6-7, 6-8 and 7-8 but I assume I just copy the same formula accross. Can anyone help me please. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate entries | Excel Discussion (Misc queries) | |||
Highlighting Duplicate Values | Excel Worksheet Functions | |||
Duplicate Entries | Excel Discussion (Misc queries) | |||
highlighting duplicate values | Excel Worksheet Functions | |||
Highlighting duplicate values in a column | Excel Discussion (Misc queries) |