IF statement with Filter

[ianjwerner]

I am trying to create a report card that uses the FILTER function and looks at date ranges.
I have it set to say IF a cell =0 the result will be from UNIQUE list
IF Not, FILTER by the Cell's value.
The IF NOT by cells value also looks at date ranges but I can't get the IF Cell = 0 also look at the dates

=IF(C8=0,UNIQUE(SOURCE!L3#),SORT(FILTER(SOURCE!L3#,(SOURCE!M3:M560=CARD!C8)*(SOURCE!R3:R560>=ORGN!AA3)*(SOURCE!R3:R560<=ORGN!AB3),"NO RESULTS")))

What can I add to this to have =IF(C8=0,UNIQUE(SOURCE!L3#) also do (SOURCE!R3:R560>=ORGN!AA3)*(SOURCE!R3:R560<=ORGN!AB3)

 

[awoohaw]

Hi,
Mr. Excel has a tool that allows you to post mini worksheets of your data/formulas. It is called xl2bb add in (Link below). Mr. Excel encourages anonymization of data (which you sort of did in your image by blocking that out). If you cannot use the add in, then please post your data as a table. Posting images, while somewhat helpful does not help the forum help you the best. The forum would have to create your scenario from scratch and that can lead to misinterpretations and errors.

Please help the forum help you.

Thanks in advance.

 

[Fluff]

Hi & welcome to MrExcel.
Maybe

=IF(C8=0,UNIQUE(FILTER(SOURCE!L3#,(SOURCE!R3:R560>=ORGN!AA3)*(SOURCE!R3:R560<=ORGN!AB3),"No Result")),SORT(FILTER(SOURCE!L3#,(SOURCE!M3:M560=CARD!C8)*(SOURCE!R3:R560>=ORGN!AA3)*(SOURCE!R3:R560<=ORGN!AB3),"NO RESULTS")))

 

[ianjwerner]

Hi & welcome to MrExcel.
Maybe

=IF(C8=0,UNIQUE(FILTER(SOURCE!L3#,(SOURCE!R3:R560>=ORGN!AA3)*(SOURCE!R3:R560<=ORGN!AB3),"No Result")),SORT(FILTER(SOURCE!L3#,(SOURCE!M3:M560=CARD!C8)*(SOURCE!R3:R560>=ORGN!AA3)*(SOURCE!R3:R560<=ORGN!AB3),"NO RESULTS")))

It works!

 

[Fluff]

Glad we could help & thanks for the feedback.