Ok, i know there is a simple way to do this(i think), but my searches dont come up with what i want.
Best way to describe is with a example.
I have a column with values like so:
1Q07
1Q07
1Q08
1Q09
1Q09
1Q09
1Q10
1Q11
1Q12
1Q12
I want the count of each unique value in a separate column like:
1Q07 | 2
1Q08 | 1
1Q09 | 3
1Q10 | 1
1Q11 | 1
1Q12 | 2
I already have the filter code in place to grab the column and filter out each unique value, so all i need now is to have the column next to it be able to count the quantity of each value.
If this is answered somewhere else and i didnt find it, feel free to link it instead. Thanks!
Matt
Bookmarks