Hi,
Can anyone explain why the formula:
='Circuit'.'CableLength'='30'
returns what I expect - ie circuits that have a length of 30
but referencing another cell:
='Circuit'.'CableLength'=A1 where A1=30
does not return any results?
Apologies if this turns out to be a very stupid question, but I've been going round in circles for a while now!
Thanks,
Dan
VW2024 Update 2
MacOS Ventura 13.6.1