Problem with filter function pulling through zeros instead of a blank cell

[MarvinH]

Hi all

I have got a problem with a filter function, it is pulling information from another data sheet that has blank cells in the data, it is pulling the blank cells through as 0 which is affecting my averages on another sheet, is it possible to make the blank cells pull through no information just as a blank cell, I cant work how to make formula work, when I add a IF statement, can you help please, here is my formula, what is the best way of pulling through blank cells as blank cells? Any help will be greatly appreciated

=FILTER('Data Input'!C3:BJ27,'Data Input'!C1:BJ1="Mon")

Many Thanks

 

[Fluff]

What version of Excel are you using? Your profile shows 2019 but that does not have the Filter function.

 

[MarvinH]

What version of Excel are you using? Your profile shows 2019 but that does not have the Filter function.

I'm using 2022 version

 

[MarvinH]

I'm using 2022 version

Sorry I forgot to update my details

 

[Fluff]

Thanks for that, how about

=LET(f,FILTER('Data Input'!C3:BJ27,'Data Input'!C1:BJ1="Mon"),IF(f="","",f))

 

[MarvinH]

Thanks for that, how about

=LET(f,FILTER('Data Input'!C3:BJ27,'Data Input'!C1:BJ1="Mon"),IF(f="","",f))

Oh my god thank you so much, that has fixed my problem, have a great weekend

 

[Fluff]

You're welcome & thanks for the feedback.