Welcome to EdListen:
Never Stop Learning

Get unique values from a column in Google Sheets, without spaces

Example spreadsheet.

Column B is: =UNIQUE(A:A)
Column C is: =ARRAYFORMULA(if(B:B="","",countif(A:A,B:B)))

Unique ~ pulls the unique values form the submissions. You can combine this inside a sort and at least variations of languages will show up close to each other.

ARRAYFORMULA ~ is a magic function that allows you to apply a formulat that is normally set for a single line to an entire dataset (aka row).

if(B:B="","", ~ is something I found on the internet that allows ArrayFormula to not process blank spaces.

If you are looking for unique matches in a data set that might contain variations of terms then I suggest the Sheet Add-on: Fuzzy Matches


=sort(UNIQUE(C2:C)) also works for grabbing a column and pulling just the unique values without spaces.

No comments:

Post a Comment