Remove Duplicates and Show and Count Unique Values in Row Zero:

Row Zero makes it easy to find, highlight, and/or remove duplicates in a spreadsheet. You can similarly find, highlight, and count unique values with ease. Here's how:

• Remove duplicates
• Conditional format duplicates
• Conditional format uniques
• Show and count unique values

How to remove duplicates in your spreadsheet:

Row Zero makes it easy to remove duplicate values in a spreadsheet with a built-in feature that works like remove duplicates in Excel and Google Sheets. Here are steps to remove duplicates:

1. Select the range of cells you would like to remove duplicates from. If you don't select a range of cells, the feature will select the entire sheet by default, which is generally recommended.
2. There are two ways to access the feature:
   • In the header menu, go to Data, Remove duplicates
   • Click the remove duplicates icon in the formatting menu in the header. Note: Depending on your screen size and zoom level, you may need to click the 3 dots to expand the menu to access remove duplicates.
3. Select the column(s) that you want to remove duplicates from. If you select mutliple columns, it will only remove duplicate rows that have duplicate values in each of the columns selected. Note that all columns are selected by default, but in many instances you may want to select just one or two columns.
4. Click Apply and all matching duplicate rows will be deleted from the sheet

Conditional format duplicates

It can sometimes be helpful to show duplicate values in your spreadsheet but not remove them. You can used Row Zero's conditional formatting feature to set the Condition to Duplicate. This will find duplicate values in the range and apply your desired formatting to highlight duplicates in your sheet. Here's how to set duplicate conditional formatting:

Conditional format uniques

Similar to duplicate conditional formatting, you can also use conditional formatting to highlight unique values that only appear once in a range by setting the Condition to Unique. Here's how to conditional format unique values:

Show and count unique values

There are a few options for showing and counting unique values in the spreadsheet:

• The COUNTUNIQUE formula creates a data table with a row for each unique value and a count of how many times the value appears in the range. Think of it as a quick pivot table count unique.

• Similarly, creating a pivot table is an easy way to drill down to unique values in a spreadsheet. Select your data range and go to Insert, Pivot table and move the field you want to see unique values for to Rows and then summarize data by these values by moving fields to Values. The simplest way to count uniques is to pull the same field to Values as Rows and select Count as the calculation to apply.

• Pivot Table count uniques values - Row Zero pivot tables have a built-in Count Unique calculation option that counts the number of unique values in a given column or field. This can be very useful for things like counting the number of unique Customer IDs that have performed a particular action or counting distinct email addresses that have logged into a website over a time period. Read more about the pivot table count unique values option here.