Compare Lists

hi ,
I had a situation in which i need to compare two lists.To Elaborate more, what i need is to compare a master database list of employees (Say for the month of Jan-2009) with the database containing list of employees for other months like Feb,Mar,Jun 2009.

For example, if an employee is present in the Jan Month.The same may or may not appear in the subsequent months in my whole database.

I need to match or Find all the similiar employees in the database.
What would be the simple formula.

My database would be like the Below:

S.No Emp Code Emp Name Department Designation Sal

for all the months.I just need to match only the employees in all the months.

Comparing lists isn't that hard, so I fear this is more involved than you're presenting.

Click GO ADVANCED and use the paperclip icon to post up your workbook. Make sure we can see a clear example of your desired output based on a complete (albeit smaller) sample data set.