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

29.09.2017 6:38:27 AM	manager	a
29.09.2017 5:53:35 AM	manager	b
28.09.2017 3:55:24 PM	manager	c
28.09.2017 3:46:49 PM	manager	d
28.09.2017 1:54:52 PM	manager	d
28.09.2017 1:11:45 PM	explorer_sessions	e
28.09.2017 1:06:50 PM	manager	f
28.09.2017 12:53:51 PM	manager	g
28.09.2017 12:33:57 PM	explorer_sessions	e
28.09.2017 10:53:48 AM	explorer_sessions	h
28.09.2017 10:43:09 AM	manager	c
28.09.2017 9:36:22 AM	manager	i
28.09.2017 9:27:25 AM	manager	d
28.09.2017 9:25:50 AM	manager	a
28.09.2017 9:19:20 AM	manager	j
28.09.2017 8:48:30 AM	manager	k
28.09.2017 8:40:19 AM	manager	d
28.09.2017 8:16:53 AM	manager	d
28.09.2017 7:59:58 AM	explorer_sessions	j
28.09.2017 7:40:07 AM	explorer_sessions	e

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[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.