Excel 2007 : Identify unique employees, and employees with a change in hours

**mcmugs** · 11-28-2010, 12:28 AM

I need to ffind a way to show the following, I have a list of employees with their assigned hours. I want to compare two months, I need to know a) if there are any unique employees, ie employee only shows up in one of the months, and b) if the employee shows up in both months compare their hours and flag/mark if the hours are not the same in both months.

**Paul** · 11-28-2010, 12:54 AM

Hi Mcmugs, welcome to the forum.

You should be able to use conditional formatting for this, but I suggest uploading a sample file that contains data matching your actual data (use fake names/data to protect confidential information). In the sample, show where matches should occur and what you'd like to see as the result.

**mcmugs** · 11-28-2010, 02:32 PM

Originally Posted by mcmugs

I need to ffind a way to show the following, I have a list of employees with their assigned hours. I want to compare two months, I need to know a) if there are any unique employees, ie employee only shows up in one of the months, and b) if the employee shows up in both months compare their hours and flag/mark if the hours are not the same in both months.

Thanks Paul

I've uploaded a sample file, what I need would be for Employees BCD, RST, BXX to be identified because they have a change in hours. I also need employees EJE and FDE to be identified because they are unique or only have one record.

**Lifesigns** · 11-28-2010, 02:54 PM

Hey there,

Think I have what you're looking for. Unique employees have blue conditional formatting and I've used:

=AND(A3=A4,B3<>B4)

As a conditional format to highlight entries that have the same name but different hours. The only thing required is that the names match exactly each month and you need to sort them by name for it to show correctly.

Hope that helps.