Count of particular unique items in a list-Revisited

Last week in the post https://www.excelforum.com/excel-for...in-a-list.html 6StringJazzer posted a great, easy to understand formula that I needed then:

Please Login or Register  to view this content.

I'm actually working with a table, so I changed it like so:

Please Login or Register  to view this content.

Now I've hit the next conundrum, which is a variation on the first. I want to get the count of UNIQUE combinations of "2024_" in the "FY_AP column" (which the first formula does) but only where the Ledger value is "FTE".

I thought it would be a simple AND, like so:

Please Login or Register  to view this content.

That formula works, in that it doesn't return a zero, but it also doesn't return the proper result. While there are four unique "2024_"'s, only 3 match with FTE, so the proper answer is 3. Any ideas on what I'm doing wrong in my formula?

You could use:

=ROWS(UNIQUE(FILTER(Table1[FY_AP],(LEFT(Table1[FY_AP],5)="2024_")*(Table1[Ledger]="FTE"))))

Wow, Rory and and Fluff13, two minds that think alike, just in different order. Both of your formulas work well! Thanks!