Question on unique display for excel

[ching quek]

I have 2 employees with pay dates: how can I display by employees' names and the unique pay dates for each unique employee

EmployeeID	EmployeeName	Pay Period Date
1	Barbara	14-09-15
1	Barbara	21-09-15
1	Barbara	28-09-15
1	Barbara	05-10-15
1	Barbara	12-10-15
1	Barbara	19-10-15
1	Barbara	26-10-15
1	Barbara	02-11-15
1	Barbara	09-11-15
1	Barbara	16-11-15
1	Barbara	16-11-15
1	Barbara	16-11-15
1	Barbara	23-11-15
1	Barbara	30-11-15
1	Barbara	07-12-15
2	Jane	14-12-15
2	Jane	14-12-15
2	Jane	21-12-15
2	Jane	28-12-15
2	Jane	28-12-15
2	Jane	28-12-15
2	Jane	04-01-16
2	Jane	04-01-16
2	Jane	11-01-16
2	Jane	11-01-16
2	Jane	18-01-16
2	Jane	25-01-16
2	Jane	01-02-16
2	Jane	08-02-16
2	Jane	08-02-16
2	Jane	08-02-16
2	Jane	15-02-16
2	Jane	22-02-16
2	Jane	29-02-16
2	Jane	07-03-16
2	Jane	07-03-16
2	Jane	14-03-16
2	Jane	21-03-16
2	Jane	28-03-16
2	Jane	28-03-16
3	Jono	04-04-16
3	Jono	11-04-16
3	Jono	11-04-16
3	Jono	11-04-16
3	Jono	18-04-16
3	Jono	25-04-16
3	Jono	25-04-16
3	Jono	02-05-16
3	Jono	02-05-16
3	Jono	09-05-16
3	Jono	09-05-16
3	Jono	16-05-16
3	Jono	23-05-16
3	Jono	30-05-16
3	Jono	06-06-16
3	Jono	06-06-16
3	Jono	13-06-16
3	Jono	20-06-16
3	Jono	27-06-16
3	Jono	04-07-16
3	Jono	11-07-16

[#2]

Hi,

I suggest to use the Remove Duplicates tool as the below screenshot:

After the Remove Duplicates dialog box shows up, please make sure that all columns are selected, and the checkbox of (My data has headers) is checked, then hit OK.

Hope that helps

[#3]

Thank you, Haytham.

I do have situations where 2 or more employees have the same pay period. Like so.....

EmployeeID	EmployeeName	Pay Period Date
1	Barbara	14-09-15
1	Barbara	21-09-15
1	Barbara	28-09-15
1	Barbara	05-10-15
1	Barbara	12-10-15
1	Barbara	19-10-15
1	Barbara	26-10-15
1	Barbara	02-11-15
1	Barbara	09-11-15
1	Barbara	16-11-15
1	Barbara	16-11-15
1	Barbara	16-11-15
1	Barbara	23-11-15
1	Barbara	30-11-15
1	Barbara	07-12-15
2	Jane	14-12-15
2	Jane	14-12-15
2	Jane	21-12-15
2	Jane	28-12-15
2	Jane	28-12-15
2	Jane	28-12-15
2	Jane	04-01-16
2	Jane	04-01-16
2	Jane	11-01-16
2	Jane	11-01-16
2	Jane	18-01-16
2	Jane	25-01-16
2	Jane	01-02-16
2	Jane	08-02-16
2	Jane	08-02-16
2	Jane	08-02-16
2	Jane	15-02-16
2	Jane	22-02-16
2	Jane	29-02-16
2	Jane	07-03-16
2	Jane	07-03-16
2	Jane	14-03-16
2	Jane	21-03-16
2	Jane	28-03-16
2	Jane	28-03-16
3	Jono	14-09-15
3	Jono	21-09-15
3	Jono	28-09-15
3	Jono	05-10-15
3	Jono	12-10-15
3	Jono	19-10-15
3	Jono	26-10-15
3	Jono	02-11-15
3	Jono	09-11-15
3	Jono	16-11-15
3	Jono	16-11-15
3	Jono	16-11-15
3	Jono	23-11-15
3	Jono	30-11-15
3	Jono	07-12-15

[#4]

Sorry, but that doesn't make sense!

I need more explanations!

There is an employee has a pay date and another one has the same one, and that's the case with Jono and Barbara! They both don't have a unique pay date!

With regards to the employee Jane, all his pay dates are unique!

[#5]

This is the case of two employees starting on the same date and subject to the same pay cycle. I like to know a method that would allow me to ask excel to restart new unique date values for every unique employee, who in this case may be starting on the same day.