I have a spreadsheet that has multiple columns (a site audit).
I am creating a template to auto-populate from the main sheet with the data other sheets with a filtered view of the data, based on specific metrics.
For instance, using the following formula in a new sheet: =filter(audit!A:A, audit!AE:AE<400, audit!E:E="Indexable")
to filter out all the URLs of pages that have less than 400 words and are indexable.
I have four columns where duplicate values can be found: audit!A:A audit!G:G audit!J:J audit!O:O
I want to insert a formula in a new sheet that will only show a filtered version of only the Duplicate values (not the unique values).
Any help would be appreciated!