cells example: a spreadsheet with 2 columns (id and flag) only.
id flag
a 1
b 1
c 2
c 3
c 10
c 10
d 1
d 2
d 6
d 12
e 1
e 7
e 8
f 1
the task is to find the ids that contain a flag greater than 11 and remove all of the rows with those ids. In this case id=d would be removed 5 rows.
id flag
a 1
b 1
c 2
c 3
c 10
c 10
d 1
d 2
d 6
d 12
e 1
e 7
e 8
f 1
the task is to find the ids that contain a flag greater than 11 and remove all of the rows with those ids. In this case id=d would be removed 5 rows.