Forum Discussion

dave_the_actuary7402's avatar
dave_the_actuary7402
Copper Contributor
Dec 14, 2020

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

Resources