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!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.