Remove duplicates based on values from two cells

[Dbjerring]

Hi Community,

Our dataset has multiple occurences of the same logs.

We would like to create another column with a "true"/"False" marking based on wether it is a duplicate or not.

We have UserID, time of log (often twice pr day) and a column with number of logged lines.

We would like to create the extra column by looking for wether there is a similar looking record with same number of logged lines and with the same userID on the same given day. 

How should we formulate the query?

Thank you in advance,

David

[Seth_C_Bauer]

@Dbjerring an example of what you are talking about and the expected output in sample form will go a long way in helping the Community answer your question.