I need help with the following scenario. I have two worksheets that I need
to compare (Employee Name Column). One worksheet has 12,000 records and the
other one has 40 records. My goal is to be able to compare both and if a
name on worksheet 2 appears on worksheet 1 get some kind of alert or have
name highlighted.

I'm working with Excel 2007.

Assuming data on the 12,000 sheet (Sheet1) is in column A and in you 40
sheet, if thats the case in B1 paste =COUNTIF(Sheet1!$A$1:$A$30,A1) and
copy down, it will give you the count of duplicates for that name.

Is that what you wanted?


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=134415

I'm not sure. What I want to do is the following: If on sheet 2 there is a
name that matches the name on sheet 1; I want to get some kind of alert. I
want to avoid doing a manual find for every name. Now sheet 1 will change
weekly and sheet 2 will stay the same. Sheet 2 is the one with 40 records.

I hope this helps. Thank you.

"Simon Lloyd" wrote:


Assuming data on the 12,000 sheet (Sheet1) is in column A and in you 40
sheet, if thats the case in B1 paste =COUNTIF(Sheet1!$A$1:$A$30,A1) and
copy down, it will give you the count of duplicates for that name.

Is that what you wanted?


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=134415

Hi,
Look into CPearson web

http://www.cpearson.com/excel/Duplicates.aspx
http://www.cpearson.com/excel/ListFunctions.aspx

if this helps please click yes thanks


"Gus Diaz" wrote:

I need help with the following scenario. I have two worksheets that I need
to compare (Employee Name Column). One worksheet has 12,000 records and the
other one has 40 records. My goal is to be able to compare both and if a
name on worksheet 2 appears on worksheet 1 get some kind of alert or have
name highlighted.

I'm working with Excel 2007.