Select the Add a status column radio button, which adds a new column highlighting duplicate values to the spreadsheet. Select the Column checkbox options there, and then click Next again. Click Next and select the Duplicates + 1st occurrences option.Ĭlick the Next button again to open the options shown directly below. Open the Dedupe and Compare feature in Power Tools by selecting Power Tools from the Add-ons pulldown menu, then selecting the Dedupe and Compare option.Ĭlick the cell reference button to select the cell range A1:A8, and press the OK option.
As such, you can utilize that tool to count all the duplicated cell content in a selected column or row. Power Tools includes a Remove duplicates option that can find all duplicate values and text within a selected cell range. Power Tools is a Google Sheets add-on that has lots of handy tools. As an example, input ‘ =COUNTA(A7:A8)‘ in B13 of your spreadsheet, which will count the duplicate text string cells as shown below. However, COUNT only works for numerical data.įor duplicated text, add the COUNTA function to the spreadsheet instead. The Sort sheet A-Z option also groups duplicated text in rows and columns within single-cell ranges. B12’s COUNT function will then return the value 2, which is the number of duplicates within the range A2:A3. Now, you only need to enter one cell reference in the COUNT function for it to count all the duplicate values within the range.įor example, enter ‘ =COUNT(A2:A3)‘ in cell B12 of your Sheets spreadsheet.