Forum Discussion
Counting text only once within date range
Hello, I'm struggling to create a formula that will count text within a column only once, but also falls within a certain date range i.e. 01/01/2025 - 31/01/2025. I'm able to create the formula to ...
hard without a 'bigger' sample as you didn't even need the UNIQUE part. I will assume the UNIQUE should be on the Company column:
=ROWS(UNIQUE(FILTER(Table1[Company], (Table1[Date]>=DATE(2025,1,1) )*(Table1[Date]<=DATE(2025,12,31) ),NA())))
Amazing! That's worked. Thank you so much! :-D