Hi All
I have a large sheet with thousands of duplicate dates and names
column A is the date
Column b is the name
01-02-16 Mike
01-02-16 Mike
01-02-16 Mike
01-03-16 Mike
01-03-16 Mike
01-02-16 John
01-02-16 John
01-03-16 John
01-03-16 John
How can I remove the duplicate dates in column A Eg 01-02-16 while keeping the names in column b Eg Mike
Answer should look like below
Duplicate removed date removed corresponding to name in column b
Any vba or formula I can use
01-02-16 Mike
01-03-16 Mike
01-02-16 John
01-03-16 John
I have a large sheet with thousands of duplicate dates and names
column A is the date
Column b is the name
01-02-16 Mike
01-02-16 Mike
01-02-16 Mike
01-03-16 Mike
01-03-16 Mike
01-02-16 John
01-02-16 John
01-03-16 John
01-03-16 John
How can I remove the duplicate dates in column A Eg 01-02-16 while keeping the names in column b Eg Mike
Answer should look like below
Duplicate removed date removed corresponding to name in column b
Any vba or formula I can use
01-02-16 Mike
01-03-16 Mike
01-02-16 John
01-03-16 John