Snasui Excel Forum

logic wrote: Thu Apr 18, 2019 1:41 pm แบบนี้ไหมครับ

F5 =IFERROR(INDEX($A$2:$A$11,SMALL(IF(ISNUMBER(MATCH($B$2:$B$11,LARGE($B$2:$B$11,{5,4,3,2,1}),0)),ROW($A$2:$A$11)-ROW($A$2)+1),ROWS(F$5:F5))),"")

ctrl+shift+enter ~~> คัดลอกสูตรลงด้านล่าง

puriwutpokin wrote: Sun Mar 31, 2019 3:10 pm ทื่ E5=TEXT(INDEX(A$2:A$11,MATCH(LARGE(B$2:B$11,D5),B$2:B$11,)),"0;;\7")+0

Bo_ry wrote: Wed Mar 27, 2019 11:45 am C2
=IF(ISNUMBER(FIND(MID(A2,1,1),B2)),MID(A2,1,1),"")&SUBSTITUTE(IF(ISNUMBER(FIND(MID(A2,1,1),B2)),MID(A2,2,1),""),IF(ISNUMBER(FIND(MID(A2,1,1),B2)),MID(A2,1,1),""),)

Bo_ry wrote: Tue Mar 26, 2019 7:22 pm C2
=SUMPRODUCT(IFERROR(AGGREGATE(15,6,(ROW($A$1:$A$10)-1)/(FREQUENCY(--MID(A2&B2,{1,2,3,4},1),ROW($A$1:$A$9)-1)>1),{1,2})*10^{0,1},))