Formula to Count Unique Values in Column based on Date Ranges in Another

[jonnycuest]

Hello,

I am looking to count unique values in 1 column with criteria that involves date ranges from TODAY()-30 and TODAY() in another column.

Unique Values in Column D:D
Date Ranges in Column V:V which need to fall between TODAY()-30 and TODAY

I can't figure out how to get both of these working together in one formula.

Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[jonnycuest]

Hello,
I have a further question on this formula:

=IFERROR(ROWS(UNIQUE(FILTER(A2:A10,(LEFT(B2:B10,10)+0>TODAY()-1)*(LEFT(B2:B10,10)+0<TODAY())))),0)

I am trying to search an entire column like B:B instead of B2:B10. Is that at all possible?
Also, what does the "+0" mean in this equation?

Thanks

 

[Fluff]

You can use whole column references, but they should be avoided as it can bring your workbook to a stop.
The +0 is to convert the text returned by Left to a number

 

[jonnycuest]

Thank you,

Could you also tell me what the 10 means in this portion? (B2:B10,10)

 

[Fluff]

Try reading up on the function, it tells you what it means.

 

[jonnycuest]

I've been googling it and I don't see anywhere that explains that

 

[Fluff]

If you type =Left( into a cell it tells you what it means.
Also I don't know what you searched for but this came up as the first reply when I tried How to use the Excel LEFT function | Exceljet

 

[jonnycuest]

oh okay thanks. I was googling ROWS. My bad

 

[jonnycuest]

So I am still having trouble with this equation:

=IFERROR(ROWS(UNIQUE(FILTER('CF - MM Main'!D:D,(LEFT('CF - MM Main'!V:V,10)+0>TODAY()-1)*(LEFT('CF - MM Main'!V:V,10)+0<TODAY())))),0)

This should return a value of 2 but it is returning a value of 0. Any ideas why?

 

[Fluff]

Looks like you have some of the brackets in the wrong place.