我有一個復雜的（至少對我而言） xmlimport 查詢 - 感謝來自這個問題的 player0 ：（將
現在要實作復選框，我們可以這樣做：
=INDEX(SUBSTITUTE(TRIM(SPLIT(FLATTEN(SPLIT(QUERY(IFNA(
CHOOSE(MATCH(MOD(SEQUENCE(999)-1, 9), {0, 1}), "?", )&QUERY(TO_TEXT(
{IF('Client Ads Served'!A2=TRUE, IMPORTXML('Client Ads Served'!H2, H6), );
IF('Client Ads Served'!A3=TRUE, IMPORTXML('Client Ads Served'!H3, H6), );
IF('Client Ads Served'!A4=TRUE, IMPORTXML('Client Ads Served'!H4, H6), );
IF('Client Ads Served'!A5=TRUE, IMPORTXML('Client Ads Served'!H5, H6), );
IF('Client Ads Served'!A6=TRUE, IMPORTXML('Client Ads Served'!H6, H6), )}),
"where Col1 is not null", )&
CHOOSE(MATCH(MOD(SEQUENCE(999)-1, 9), SEQUENCE(9)-1),
"?","?","?","?","?","?","?","?","?")),,9^9), "?")), "?")), "? ", "/"))
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/345200.html