Newb needs help.

G

Gus Diaz

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.
 
S

Simon Lloyd

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

Is that what you wanted

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com
 
Top