5. Reduce multiple formula steps with Google Sheets’ ArrayFormula Another Google Sheets trick that I find useful is the ArrayFormula.

We show you how to highlight duplicates in Google Sheets using the COUNTIF and ARRAYFORMULA functions under the conditional format rules.