Forum Discussion
XLOOKUP multiple lookup values and return checkbox if all return values <> a specified value!
I have to be overthinking this, but I can't keep "spinning my wheels" - Any advice would be very much appreciated! I have two worksheets. I have attached an example with parts of the worksheets in t...
This kind of output?
select * from Sheet2 limit 3;
select * from Sheet1 limit 3;
cli_one_dim~Sheet1~5;
select `Serial No.`,count(*),sum(f02='Sold'),group_concat(f01||f02),iif(count(*)=sum(f02='Sold'),'√','') `All Trades Sold` from Sheet1union left join Sheet2 on 数量=f01 group by `Serial No.`;