FILTER COMMAND

Post Reply
SRF
Posts: 33
Joined: Thu Sep 18, 2025 9:17 am

FILTER COMMAND

Post by SRF »

Hi - It's great to see XLOOKUP and FILTER being supported in Planmaker. However, this formula - which attempts to set two conditions for a filter - isn't working:

=FILTER($B$2:$C$5,($B$2:$B$5<3)*($C$2:$C$5="b"))

It returns a #CALC! error.

What am I doing wrong?
SRF
Posts: 33
Joined: Thu Sep 18, 2025 9:17 am

Re: FILTER COMMAND

Post by SRF »

I'm so sorry - please ignore this - my conditions were not met by any data in the array, hence the #CALC! error. My fault.
Post Reply

Return to “BETA: PlanMaker NX and 2026 for Linux”