Remove rows where field values are the same for unique identifiers

[CD11]

I am busy cleaning timesheet data and would like to remove those people that do not fill theirs in accurately and submit the same amount of hours each day (person A in table below).  Is there a way I can add in a rule to this effect? i.e. For each individual with the same name, if hours variable is constant remove these observations - data for person A would be deleted and data for person B retained

Person	Hours worked per day
A	12
A	12
A	12
B	9
B	15
B	13

Thank you!

[danilang · Accepted solution]

Hi @CD11

If you perform countdistinct of the values grouped by person, you'll then be able to filter out those below some threshold

 

Note that I added a person C to your input data to have a bit more variety.

Dan

[CD11]

Thank you - works perfectly!