Re: อยากทราบสูตรการสลับตัวเลข 7 และ 8 ตัว
Posted: Mon May 22, 2023 8:13 pm
by norkaz
...
ไม่ค่อยเข้าใจที่สอบถามมา
ลองปรับล้อกับสูตรเดิม ประมาณนี้ครับ
แบบ 8 ตัว
D4
=INDEX(MID($B$1,{"1","1","1","1","1","1","1","1","1","1","1","1","1","1","1","1","1","1","1","1","2","2","2","2","2","2","2","2","2","2","2","2","2","2","2","3","3","3","3","3","3","3","3","3","3","4","4","4","4","4","4","5","5","5","6"},1)&MID($B$1,{"2","2","2","2","2","2","3","3","3","3","3","4","4","4","4","5","5","5","6","6","3","3","3","3","3","4","4","4","4","5","5","5","6","6","7","4","4","4","4","5","5","5","6","6","7","5","5","5","6","6","7","6","6","7","7"},1)&MID($B$1,{"3","4","5","6","7","8","4","5","6","7","8","5","6","7","8","6","7","8","7","8","4","5","6","7","8","5","6","7","8","6","7","8","7","8","8","5","6","7","8","6","7","8","7","8","8","6","7","8","7","8","8","7","8","8","8"},1),ROWS(D$4:$D4))
แบบ 7 ตัว
H4
=INDEX(MID($F$1,{"1","1","1","1","1","1","1","1","1","1","1","1","1","1","1","2","2","2","2","2","2","2","2","2","3","3","3","4","4","5"},1)&MID($F$1,{"2","2","2","2","2","3","3","3","3","4","4","4","5","5","6","3","3","3","3","4","4","4","5","5","4","4","4","5","5","6"},1)&MID($F$1,{"3","4","5","6","7","4","5","6","7","5","6","7","6","7","7","4","5","6","7","5","6","7","6","7","5","6","7","6","7","7"},1),ROWS(H$4:$H4))
========
ถ้าใช้ตารางมาช่วย (Helper)
แบบ 8 ตัว
สร้างตารางที่ AD4:AFxx
E4 คีย์
=INDEX(MID($B$1,$AD$4:$AD$58,1)&MID($B$1,$AE$4:$AE$58,1)&MID($B$1,$AF$4:$AF$58,1),ROWS(E$4:E4))
แบบ 7 ตัว สร้างตารางที่ AH4:AJxx
I4 คีย์
=INDEX(MID($F$1,$AH$4:$AH$33,1)&MID($F$1,$AI$4:$AI$33,1)&MID($F$1,$AJ$4:$AJ$33,1),ROWS(I$4:I4))
** คลิกโฆษณาหน้าเพจ เพื่อสนับสนุนฟอรั่มครับ **
Norkaz