How to Highlight Duplicates on Google Sheets on Android

Written by Nicole Levine, MFA

This wikiHow teaches you how to find duplicate cells in a column using Google Sheets on your Android.

Steps

It’s the green icon with a white table outline (labeled “Sheets”) in the app drawer. You may also find it on your home screen.
The contents of the spreadsheet will appear.

Advertisement
Be sure to tap the letter above the column that contains the data you wish to check for duplicates. This will highlight the entire column.
It’s the third icon at the bottom of the screen. A pop-up menu will appear.
You may have to scroll down to find it. This opens the “Create a rule” window.
Now you’ll see a blank under “Custom formula.”
7
Type =countif(G:G,G1)>1 into the blank. This formula checks all values in column “G” (starting with G1) that appear in more than one cell. In this example, “G” is the letter at the top of the column—you’ll need to replace “G” with the letter that’s at the top of the column you selected.
- For example, if you clicked the A column, you would type =countif(A:A,A1)>1 into the blank.
It’s at the top-right corner of the screen. This saves your custom formula and brings you back to your spreadsheet. You will now see all cells in the column that contain duplicates in a different color.

Advertisement

Search

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.