|Not sure this is what your looking for, but |
To Find Duplicate data in two columns:
1st - Highlight Column Data Cells
I.E. Column J Cells 1-50 and Column N Cells 1-50
On the Menu Bar select:
2nd - Format
3rd - Conditional Formatting
4th – Change “Cell Value is” to “Formula Is”
5th – Enter the formula:
Sub Menu Format :
6th - Patterns
7th - Choose a pretty color
8th - Press OK
9th - Press OK
All your duplicate records should now be highlighted in your selected pretty color.
There are other ways of doing this.
One other way is to use the EXACT function.
In the top cell of a BLANK column enter the formula:
Then copy the forumula down
You will see the word "TRUE" for those cells that Match
and "FALSE" for those cells that do not Match.
The advantage here is that you can now sort your whole
sheet on the "TRUE or FALE" column, which might be handy.