Need Help with Highlighting duplicates across several sheets

[mikerickson]

For each sheet create a dynamic named range
Name: myNames1 RefersTo: = OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)
Name: myNames2 RefersTo: = OFFSET(Sheet2!$A$1,0,0,COUNTA(Sheet2!$A:$A),1)
Name: myNames3 RefersTo: = OFFSET(Sheet3!$A$1,0,0,COUNTA(Sheet3!$A:$A),1)
etc.
Also create a name
Name: lastHired RefersTo:INDEX(myNames1,ROWS(myNames1),1)

Then =IF(OR(MATCH(lastHired,myNames1,0)<ROWS(myName1), ISNUMBER(MATCH(lastHired,myNames2,0)), ISNUMBER(MATCH(lastHired,myNames3,0))), "Duplicate", "Not Duplicate")

 

[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

 

[Herbert Seidenberg]

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