Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
looking for duplicate rows
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 Rows | Excel Worksheet Functions | |||
how to duplicate rows? | Excel Discussion (Misc queries) | |||
Duplicate rows into new rows based on row value | Excel Worksheet Functions | |||
Duplicate rows, put in another value | Excel Worksheet Functions | |||
Duplicate rows Elimination- change rows accordingly | Excel Programming |