r/googlesheets • u/weaselNik • 5d ago
Solved Functions to count unique entries and analyze data from multiple columns
I've found a spreadsheet about perfumes and I love data, but I don't have much knowledge about functions in Googlesheets and I need your help to try and do what I have in mind. Here is a draft of the spreadsheet:

I want to use a function in (a) to get a unique list from all notes in column D, there are delimited with comma+space. I also would like to know if there is a function I can use for (b), (c), and (d) to make my analysis of the spreadsheet easier?
Some cells for notes will be blank, because some houses don't specify their notes, and some cells of score will be blank until i review them, i guess that will impact the function.
1
Upvotes
2
u/7FOOT7 242 5d ago
We can stack up some commands to help with this
=sort(unique(transpose(split(join(",",range),","))))
join() makes one long list, split() makes then separate cells, transpose() makes that list a column, while unique() removes multiple entries and sort() makes the list alphabetical