同欄多筆不固定行數資料 取前面相同的後面數據 (14963)

C3:E6{=IFERROR(MID(VLOOKUP(CHOOSE(COLUMN(A1),"USER*","ACTION*","STATUS*"),OFFSET($A$1,MAX(SMALL(IF((LEFT($A$3:$A$25,4)="USER")*(MID($A$4:$A$26,7,19)="2026-03-30"),ROW($2:$24)),ROW(A1))),,9),1,),6+($C$2<>C$2)*2,99),"")



留言