Forum Discussion
List months and totals
Hello, So I want to create a formula that would reference a Column in another worksheet, the referenced Column will have a list of dates and I would like to pull out Month and year and count the numb...
Hi jaolvera
I think you can use FREQUENCY combine with UNIQUE to solve this.
FREQUENCY has two parameters; first is data range and second is a "bin" to group the count. UNIQUE give us a unique list of
Example lets say your dates are in column A21 to A27. Below formula gets the unique values in range A21 to A27 and the frequency of the number of count.
=IFNA( TEXT(SORT(UNIQUE(A21:A27)), "mmm yy") & " - " & FREQUENCY(A21:A27, SORT(UNIQUE(A21:A27))), "")