Table Filter Formula, No data, return words "No Data"

[nickpavlov]

Hello,

I am trying to add a No Data return value to the below, but I still get a #NAME? returned when no data is found within the filter results.

=FILTER(INDEX(TData,SEQUENCE(ROWS(TData)),{3,2,1,5}),IF(B4="All",1,TData[Charity Name]=B4)*(TData[Unit Date]>=C2)*(TData[Unit Date]<=C3)*IF(B5="All",1,TData[Unit ID]=B5),?No Data?)

I appreciate any help.

Thank you,
Nick

[Kaper]

how about:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[Fluff13]

You need to replace the ? marks around No Data with quotes "

[AliGW]

Best guess, based on your formula, is that you are using curly quotes. Make sure they are straight:

=FILTER(INDEX(TData,SEQUENCE(ROWS(TData)),{3,2,1,5}),IF(B4="All",1,TData[Charity Name]=B4)*(TData[Unit Date]>=C2)*(TData[Unit Date]<=C3)*IF(B5="All",1,TData[Unit ID]=B5),"No Data")

[nickpavlov]

Interesting, on my formula it is "No Data", but when I copied it over here it copied with ?No Data?

[nickpavlov]

But when I retyped the formula, it decided to work now. Thank you everyone!

[Fluff13]

Glad to help & thanks for the feedback.

[AliGW]

Interesting, on my formula it is "No Data", but when I copied it over here it copied with ?No Data?

That's how I knew you'd used curly quotes - the forum will not display anything but straight ones.