CODEWITHSUNDEEP
google-sheets
F. Vosnim
F. Vosnim

Reputation: 574

How to show duplicates on 2 google sheets at the same time?

This conditional format command shows duplictes on the Sheet1 perfectly:

Appliy to range A:A
=COUNTIF(A:A,A1)>1

Is it possible make it work with Sheet2 at the same time. I've read that INDIRECT could help but I don't understand how to do that.

I tried this with no luck:

Upvotes: 0

Views: 205

Answers (1)

Tom Sharpe
Tom Sharpe

Reputation: 34325

If you want it to check both sheets for duplicates, you can still use almost the same formula, but you have to put the references into an Indirect statement:

=countif(INDIRECT("Sheet1!A:A"),A1)+countif(INDIRECT("Sheet2!A:A"),A1)>1

as mentioned in the documentation

Upvotes: 1

Related Questions