Remove Duplicate Values Against same date and same name data

[shatan]

Hi All,
Got an interesting query to ask..
Trying to work on a formula for the below,
I need to remove duplicates that match on the same day..
So if the day and month is the same and the column c letter is the same then remove the duplicate.

I cant seem to find a function or macro that could do this for me?
any help appreciated

[TABLE="class: grid, width: 492, align: center"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]29.09.2017 6:38:27 AM[/TD]
[TD]manager[/TD]
[TD]a[/TD]
[/TR]
[TR]
[TD]29.09.2017 5:53:35 AM[/TD]
[TD]manager[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD]28.09.2017 3:55:24 PM[/TD]
[TD]manager[/TD]
[TD]c[/TD]
[/TR]
[TR]
[TD]28.09.2017 3:46:49 PM[/TD]
[TD]manager[/TD]
[TD]d[/TD]
[/TR]
[TR]
[TD]28.09.2017 1:54:52 PM[/TD]
[TD]manager[/TD]
[TD]d[/TD]
[/TR]
[TR]
[TD]28.09.2017 1:11:45 PM[/TD]
[TD]explorer_sessions[/TD]
[TD]e[/TD]
[/TR]
[TR]
[TD]28.09.2017 1:06:50 PM[/TD]
[TD]manager[/TD]
[TD]f[/TD]
[/TR]
[TR]
[TD]28.09.2017 12:53:51 PM[/TD]
[TD]manager[/TD]
[TD]g[/TD]
[/TR]
[TR]
[TD]28.09.2017 12:33:57 PM[/TD]
[TD]explorer_sessions[/TD]
[TD]e[/TD]
[/TR]
[TR]
[TD]28.09.2017 10:53:48 AM[/TD]
[TD]explorer_sessions[/TD]
[TD]h[/TD]
[/TR]
[TR]
[TD]28.09.2017 10:43:09 AM[/TD]
[TD]manager[/TD]
[TD]c[/TD]
[/TR]
[TR]
[TD]28.09.2017 9:36:22 AM[/TD]
[TD]manager[/TD]
[TD]i[/TD]
[/TR]
[TR]
[TD]28.09.2017 9:27:25 AM[/TD]
[TD]manager[/TD]
[TD]d[/TD]
[/TR]
[TR]
[TD]28.09.2017 9:25:50 AM[/TD]
[TD]manager[/TD]
[TD]a[/TD]
[/TR]
[TR]
[TD]28.09.2017 9:19:20 AM[/TD]
[TD]manager[/TD]
[TD]j[/TD]
[/TR]
[TR]
[TD]28.09.2017 8:48:30 AM[/TD]
[TD]manager[/TD]
[TD]k[/TD]
[/TR]
[TR]
[TD]28.09.2017 8:40:19 AM[/TD]
[TD]manager[/TD]
[TD]d[/TD]
[/TR]
[TR]
[TD]28.09.2017 8:16:53 AM[/TD]
[TD]manager[/TD]
[TD]d[/TD]
[/TR]
[TR]
[TD]28.09.2017 7:59:58 AM[/TD]
[TD]explorer_sessions[/TD]
[TD]j[/TD]
[/TR]
[TR]
[TD]28.09.2017 7:40:07 AM[/TD]
[TD]explorer_sessions[/TD]
[TD]e[/TD]
[/TR]
</tbody>[/TABLE]

 

[Zubair Muhammad]

Hi,
See if this works

Assuming your data starts from A1 insert this formula in cell D1 and drag

=LEFT(A1,5)&C1

Then use remove duplicate button from data tab

 

[shatan]

Hi,
See if this works

Assuming your data starts from A1 insert this formula in cell D1 and drag

=LEFT(A1,5)&C1

Then use remove duplicate button from data tab

Thanks Muhammad.
That works but i still need a single entry from each duplicate (sorry)

 

[shatan]

dont worry it was being stupid. thanks again that helped

 

[Yoavagabond]

Thanks Muhammad.
That works but i still need a single entry from each duplicate (sorry)

I just registered to say thank you! You have no idea how much time you've saved me, dear Muhammad.