如何修改此
指定順序 標題按所需順序標有數字。原始公式將尋找“是”并將其替換為范圍內任何問題的標題值并作為索引輸出
然后，第二個公式將按字母順序拆分和排序值，然后 REGEXREPLACE 數字。
非常感謝結合這兩個公式的任何幫助！
設定#1：
=index(substitute(substitute(trim(transpose(query(transpose(if(B2:E<>"yes",,substitute(B1:E1," ","??"))),,9^9)))," ",", "),"??"," "))
和
=TRIM(REGEXREPLACE(JOIN(",",SORT(TRANSPOSE(SPLIT(E2,",")))),"\b\d_",""))
替代套裝#2
INDEX(REGEXREPLACE(TRIM(FLATTEN(QUERY(TRANSPOSE( IF(B2:E="yes", B1:E1&",", )),,9^9))), ",$", ))
和
=TRIM(REGEXREPLACE(JOIN(",",SORT(TRANSPOSE(SPLIT(E2,",")))),"\b\d_",""))
預先感謝您的幫助！
共享的谷歌表在
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/456351.html
上一篇：如何通過相鄰列中的資料從UNIQUE和COUNTIF中進行選擇？
下一篇：具有2個條件的過濾公式