尾数相同数据 提取 (10989)

AO:AQ16{=IFERROR(INDEX(4:4,SMALL(IF(RIGHT($B4:$U4)-$AI4=0,COLUMN($B:$U)),COLUMN(A1))),AN4)

另解{=IFERROR(INDEX($B4:$U4,SMALL((RIGHT($B4:$U4)<>$AI4&"")/1%%+COLUMN($A:$T),COLUMN(A1))),AN4)