Reputation: 23
I have a Google spreadsheet with a column that looks like this:
Each cell is dropdown list containing Fruits = [Apple,Orange,Pineapple,Papaya,Cherry,Strawberry]
Apple
Orange
Pineapple
Papaya
Cherry
Strawberry
Apple
Orange
Cherry
I want to count how many types of fruits are there. (Google sheet formula)
Apple, Orange and Cherry occurring twice.
There are 6 different types of fruits in column.
How do i do that?
Upvotes: 2
Views: 91
Reputation: 27312
If I understood correctly and assuming the fruits are in the range A2:A10, you should be able to use
=countunique(A2:A10)
Change range to suit and see if that helps?
Upvotes: 2