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

Learn how Google Sheets gives you tools to sort ranges, compare cells, and remove duplicates quickly.

Install the Remove Duplicates add-on from the Google Workspace Marketplace. In your sheet, click Extensions, then Remove Duplicates, and choose: Find Duplicates or Uniques.

Thinking Ahead To Save Time One thing about conditional formatting: It can be very time-consuming to replicate a formula over and over for a given cell and replace, one by one, each reference to a ...

You can use VLOOKUP with Google Sheets; it's similar to how the function works in Excel. The VLOOKUP formula can find values in tables on the same sheet or a different sheet, but it can only find ...