Removing duplicates in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the UNIQUE() function do in Google Sheets?

The UNIQUE() function returns a list of unique values from a range, removing any duplicates.

beginner

How do you remove duplicate rows from a dataset in Google Sheets?

You can use the Data > Data cleanup > Remove duplicates menu option or use the UNIQUE() function to create a list without duplicates.

beginner

What happens if you use =UNIQUE(A2:A10) on a list with repeated names?

It will return a list of names from A2 to A10 but only show each name once, removing repeated entries.

intermediate

Can UNIQUE() function handle multiple columns?

Yes, UNIQUE() can take multiple columns as input and will remove duplicate rows based on all columns combined.

intermediate

What is the difference between using the menu option 'Remove duplicates' and the UNIQUE() function?

The menu option removes duplicates directly from the original data, changing it. The UNIQUE() function creates a new list without duplicates, leaving original data unchanged.

Which function in Google Sheets removes duplicate values from a range?

A FILTER()

B REMOVE()

C UNIQUE()

D SORT()

The UNIQUE() function returns only unique values from a range, removing duplicates.

What does the 'Remove duplicates' option under Data menu do?

A Removes duplicate rows from the selected range

B Highlights duplicates

C Sorts data alphabetically

D Deletes the entire sheet

It removes duplicate rows from the selected range, keeping only unique rows.

If you want to keep the original data unchanged but get a list without duplicates, what should you use?

A Delete duplicates manually

B Use UNIQUE() function

C Use Remove duplicates menu option

D Use SORT() function

UNIQUE() creates a new list without duplicates, leaving original data intact.

Can UNIQUE() remove duplicates based on multiple columns together?

A Yes, it considers all columns in the range

B Only if columns are sorted

C No, only one column at a time

D Only if columns have numbers

UNIQUE() treats multiple columns as combined keys and removes duplicate rows accordingly.

What will =UNIQUE(A2:A10) return if A2:A10 contains: Apple, Banana, Apple, Orange?

A Apple only

B Apple, Banana, Apple, Orange

C Banana, Orange

D Apple, Banana, Orange

UNIQUE() returns only one instance of each value, so duplicates like the second Apple are removed.

Explain how to remove duplicates from a list in Google Sheets without changing the original data.

Think about a function that filters unique values.

Describe the difference between using the 'Remove duplicates' menu option and the UNIQUE() function.

One changes your data directly, the other keeps it safe.