Count Unique Instances of Date while filtering based upon date and ID #

Hello,

I've been browsing several forums to try and find the answer to this, so far none of the suggested formulas have worked when I've copied them.

I have a list of ID# (Col A) and dates (Col B). The ID # of reference is Col (F) and today's date (Col G). I need to count how many future dates there are in the list (Col B) that are unique and in the future from today's date.

Any tips would be greatly appreciated, I'm still fairly new to all these formulas and functions which is why I'm not attempting this in VBA.

I've attached an example work book and I would like the result in H2.

Thanks for replying!

That counted all the future dates tied to that ID# and returned 7. How would I go about only returning the unique dates?

The goal of this example would be to return 4 as the ID# 1234567 appears 7 times but only on 4 distinct dates.

Does that make sense?

Originally Posted by Tony Valko

Try this array formula**:

=SUM(IF(FREQUENCY(IF(A2:A12=F2,IF(B2:B12>G2,B2:B12)),B2:B12),1))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

That is exactly what I needed! Thank you so much, just made my Friday!