Need Help with Highlighting duplicates across several sheets

V

vote4pedro

Hello,

I only know the basics within Excel and I need to develop a spreadshee
that has 3 sheets within a spreadsheet and highlight duplicate name
entered across all 3 sheets.

Example: sheet 1 will be my primary sheet were all data will be entere
and I have it labeled as "New Hires" and as people are hired the name
will be entered into this sheet.

I also have sheet 2 and sheet 3 which I have not specified a label fo
them yet, but they will have names in these sheets that already wor
for the company.

When names are entered in the "New Hires" sheet and if it is
duplicate name that may be already entered in Sheet 2 or Sheet 3
would like for it to be Highlighted to alert me that there is
duplicate name.

Is this possible? If so I would greatly appreciate the help.
I only know the basics, please break it down into newbie terms.

I was able to get the first sheet to work with the this formula:
=IF(MAX(COUNTIF(INDIRECT("A2:A"&(MAX((A6:A500<>"")*ROW(A6:A500)))),INDIRECT("A2:A"&(MAX((A6:A500<>"")*ROW(A6:A500))))))>1,"Duplicat
Name Exists !!!!","No Duplicates")

and this formula:
=COUNTIF($A$1:$J$500,A4)>1

but I can't figure out how to do this across multiple sheets withi
Excel

Thanks Alo
 

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

Top