Hello,

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

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

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

When names are entered in the "New Hires" sheet and if it is a
duplicate name that may be already entered in Sheet 2 or Sheet 3 I
would like for it to be Highlighted to alert me that there is a
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,"Duplicate
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 within
Excel

Thanks Alot




--
vote4pedro

Excel 2007 only.
Uses COUNTIFS()
http://www.savefile.com/files/1763191