How To Set Up A Specific Filter

Hi

I would like to create a filter comparing the fields:

SCOTT# to SCOTT#

I managed to select SCOTT# field contains SCOTT#, this is the unique key, it is always different.

I wondered if I could use a filter to show the records with the same SCOTT#, without having to enter the number.

Thank you,
Mary

Have you tried using the grouping feature instead of a filter?

Also, if you’re trying to dedupe, there is a block for that on the Pro plan.

Hi @Mac

Thank you for your reply.

I will look into the grouping feature.

I am using the free plan, so I don’t believe I have this block.

Thank you,
Mary