Forum Discussion
count totally unique values, that occur in a certain year
trying to create a simple tracking document for new client referrals, working in Office 365 I used =COUNTA(UNIQUE(B2:B6)) to count the number of unique names across all years, which tells me the ...
See the attached sample workbook. I used two helper columns (and I used the month number instead of the month name).
- hi THANK YOU SO MUCH
I created the helper columns but Office 365 does not appear to have the array functions you use 😞 they only have an "array to text" optionThe functions I used should be available in Excel in Microsoft 365...
