問題:將列標題,按升序排列,相同顯示=號

解題:先把列標題按數(shù)字升序排列,再生成對應分隔符

=CONCAT(SORTBY(B$1:D$1,B2:D2,1)&IFERROR(IF(SMALL(B2:D2,{1,2,3})=SMALL(B2:D2,{2,3,4}),"=","<"),""))

數(shù)組3鍵

UP小賴同學愛學習

點贊出視頻