Friday, October 7, 2016

Copy Unique Values in Google Sheets


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

1 comment: