Forum Discussion

ELingo2275's avatar
ELingo2275
Copper Contributor
Sep 01, 2024

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 ...
excel
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Sep 01, 2024

ELingo2275 

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.

  • Kidd_Ip's avatar
    Kidd_Ip
    MVP
    Sep 02, 2024

    HansVogelaar 

     

    How about this:

     

    =SORT(UNIQUE(A1:A30))

     

    =COUNTIF($A$1:$A$30, B1)

Resources