Removing duplicates in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to remove duplicates from the range A1:A10.

Google Sheets

=UNIQUE([1])

Drag options to blanks, or click blank then click option'

AA10

BA1

CA1:A10

DA1:A9

Attempts:

3 left

💡 Hint

Common Mistakes

Using a single cell instead of a range.

Selecting a range that does not include all data.

The UNIQUE function removes duplicate values from the specified range. Here, the range A1:A10 is used to get unique values.

2fill in blank

medium

Complete the formula to remove duplicates from columns A and B together (rows 1 to 10).

Google Sheets

=UNIQUE([1])

Drag options to blanks, or click blank then click option'

AA1:B10

BA1:A10

CB1:B10

DA1:B9

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting only one column when duplicates depend on multiple columns.

Using an incomplete range.

To remove duplicates based on multiple columns, provide the range covering those columns. Here, A1:B10 covers columns A and B for rows 1 to 10.

3fill in blank

hard

Fix the error in the formula to remove duplicates from the range C2:C20.

Google Sheets

=UNIQUE([1])

Drag options to blanks, or click blank then click option'

AC2:C20

BC2-C20

CC2;C20

DC2:C2O

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dash '-' instead of a colon ':'.

Using semicolons or misspelled cell references.

The correct range syntax uses a colon ':' between start and end cells. 'C2:C20' is valid, while others cause errors.

4fill in blank

hard

Fill both blanks to remove duplicates from the range D1:E15 and sort the results ascending.

Google Sheets

=SORT(UNIQUE([1]), [2], TRUE)

Drag options to blanks, or click blank then click option'

AD1:E15

B1

C2

DFALSE

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong range or column number.

Confusing TRUE/FALSE for ascending/descending.

The UNIQUE function removes duplicates from D1:E15. SORT then sorts by the first column (1) ascending (TRUE).

5fill in blank

hard

Fill all three blanks to remove duplicates from A2:C20, sort by the second column descending, and display only the first 5 rows.

Google Sheets

=INDEX(SORT(UNIQUE([1]), [2], [3]), SEQUENCE(5))

Drag options to blanks, or click blank then click option'

AA2:C20

B2

CFALSE

DTRUE

Attempts:

3 left

💡 Hint

Common Mistakes

Using TRUE instead of FALSE for descending.

Not limiting rows with INDEX and SEQUENCE.

UNIQUE removes duplicates from A2:C20. SORT sorts by column 2 descending (FALSE). INDEX with SEQUENCE(5) shows the first 5 rows.