GOAL
Copy unique values from one column to another column in Google Sheets (or Excel).
SOLUTION
=UNIQUE(A1:A10)
A1:A10 is the range of cells you hope to narrow to only unique values
EXAMPLE
Column A:
|
Column B: Use this formula:
=UNIQUE(A1:A13)
and get the following:
|
Dogs
Dogs
Cats
Dogs
Dogs
Dogs
Cats
Snakes
Cats
Turtles
Dogs
Dogs
Cats
|
Dogs
Cats
Snakes
Turtles
|