How to Get the Unique Values of a Column in a Google Docs Spreadsheet
I recently had the need to get all the unique values in cells within a column, by comma delimited.
Here’s the function I used:
=query(index(unique(trim(transpose(split(join(" ",A1:A&","),","))))),"select* where Col1 '' ")
I put his in B1 and it listed all the unique values from A:A and it automatically updates as you change the data in A:A