duplicated in two worksheets with highlights

P

Pammy

I have two worksheets with 18,000 rows of infor. I want to see the
duplications that exist in the two worksheets. On sheet 2 in col C, and in
col D is the formula:
=countif(sheet1!b2:b18000,c2)>0,"yes"," ") this brings back a yes in all
the rows with duplicates that exist on sheet 1. I also did the same formula
on sheet 1 so it will show me the duplicates also. Question: is there a way
to highlight the duplicates with different colors so when I look on sheet 2
and see a yes, I can look at sheet 1 and find that duplicate number easily by
the highlighted matching color.
Thanks,
 
E

Earl Kiosterud

Pammy,

Sort the table on column B. The duplicates will then be together,
vertically. You can use the same formula to identify them. Be careful if
you're not familiar with Excel sorts. DO NOT select only one column -- it
will gladly do the "Sort of Disaster."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Matching Rows with Multiple Columns in Two Worksheets 0
Working outlook via vba code with xlsx - error 0
Combination of INDEX MATCH FREQ ROW INDIRECT - find unique values using2 conds with UIDs that may ha 0
External cell reference between two excel worksheets both in One Drive 0
Marco to rename worksheets from list 4
Conditional Format Formula for finding duplicates in a row 1
Code to format cells on several worksheets 2

Top