Forum Discussion
Frequency distribution for unique values
I have a list of tree species and need to figure out the frequency distribution for each species. I know how to get a list of the unique tree species =SORT(UNIQUE(A1:A30)). However I'm unsure how to ...
Let's say your formula =SORT(UNIQUE(A1:A30)) is in cell K1.
In L1:
=COUNTIF(A1:A30, K1#)
Alternatively, create a pivot table based on the data, and add the tree species column to both the Rows area and the Values area.
