Forum Discussion
dave_the_actuary7402
Dec 14, 2020Copper Contributor
FILTER Function Excel
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
No RepliesBe the first to reply