Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
180
Views
Topic starter
I have this in a cell.
=FILTER(Calculations!A11:G61,(Calculations!C11:C61="Y")*(Non_Excludable),"")
I am getting #VALUE
Non_Excludable is a named range. It is this range Calculations!$B$11:$B$61
Posted : 16/12/2020 7:54 pm
Hi David,
There's no logical test for the Non_Excludable criteria, so it won't work unless that named range returns an array of Boolean values.
Mynda
Posted : 17/12/2020 12:13 am
Topic starter
The range did return Booleans. My problem was that some of them were blank. I fixed it. Thank you for you help.
Posted : 17/12/2020 4:10 pm
