Filter for 2nd Row of each 'like' or duplicate record in column

[wonka1234]

Hi,

How can I filter my dataset for the second row in each 'book'?

How can I keep only the record in red?

[DataNath · Accepted solution]

@wonka1234 are there only ever 2 books? If so, could just use the sample tool like so:

Before - 

After -

If not, you can create an ID for the records of each book and then just filter those that = 2:

Before - 

After - 

[Emmanuel_G]

Hi @wonka1234 ,

Here's a solution which keep these rows only with two methods 

Let me informed if it works as you want.

Cheers !