UNIQUE works to find how many unique items are in a list.
FILTER can help this by further narrowing a unique list based on if this equals that, as an example.
COUNTA relays the number of results.
I'm trying to use these to find how many unique blocks of data fall within a filtered service date. But I only get so far using the UNIQUE(FILTER(...)) formula I'm used to. It's like I need to use a version of UNIQUE(FILTER(UNIQUE(...))) in order to narrow down my results further to unique blocks. But I dont think UNIQUE(FILTER(UNIQUE(...))) is a thing. So maybe I need a helper column.
I've attached an animation and a sample sheet for your use. I'm using autofilter in the example only to demonstrate a result I see, that I need Excel to "see".
(Sorry for the misspellings)
Animation.gif
Bookmarks