以MAX_TT列的F3单元格内TOP1行的值 取对应B3单元格行的值
INDEXOFARRAY(REVERSEARRAY(SORTARRAY(UNIQUEARRAY(SPLIT(REPLACE(F4," ",0),",")))),1)
indexofarray(reversearray(sortarray(maparray(SPLIT(REPLACE(b3,"/",0),","),round(nvl(item,0),2)))),1)
INDEXOFARRAY(SPLIT(b3,","),1)
INDEXOFARRAY(SPLIT(b3,","),2)
INDEXOFARRAY(SPLIT(b3,","),3)
INDEXOFARRAY(REVERSEARRAY(SORTARRAY(SPLIT(REPLACE(b3,"/",0),","))),1)
去重
INDEXOFARRAY(REVERSEARRAY(SORTARRAY(UNIQUEARRAY(SPLIT(REPLACE(b3,"/",0),",")))),1)
INDEXOFARRAY(REVERSEARRAY(SORTARRAY(SPLIT(A3,","))),1) ---第一
INDEXOFARRAY(REVERSEARRAY(SORTARRAY(SPLIT(A3,","))),2)----第二
-----------
E4[!0]{SORT(F4)=1}
E4[!0]{SORT(F4)=2}
E4[!0]{SORT(F4)=3}