Finding Unique Values Based on Dates

[zalik22]

Hi,

I have some data, column A is text terms, and column F is 52 week ending dates. Is there a way to show only the unique values in column G? For example, if G1 is 1/8/24, G2 and below would only show the column A terms that are in 1/8/24 week ending but not in 1/1/24 week ending (i.e. new terms)?

Thanks!

 

[zalik22]

My take on this

=FILTER(A2:A100,(F2:F100=G1)*(COUNTIFS(F:F,"<"&G1,A:A,A2:A100)=0))

Hi, I put 1/8/24 in G1 and it appears to work for 2 weeks worth of data.

I added week ending 1/15/24 data and there was a term that was not in 1/8/24 but in 1/1/24 so it's not showing up. I would like the term to show up since it was not in the previous week but there 2 weeks ago.

Is there a way to modify the formula to just compare to the previous week instead of all previous weeks?

 

[Fluff]

Ok, how about

=FILTER(A2:A100,(F2:F100=G1)*(COUNTIFS(F:F,G1-7,A:A,A2:A100)=0))

 

[zalik22]

Ok, how about

=FILTER(A2:A100,(F2:F100=G1)*(COUNTIFS(F:F,G1-7,A:A,A2:A100)=0))

Perfect thanks a lot!

 

[Fluff]

Glad we could help & thanks for the feedback.