อยากทราบสูตรการสลับตัวเลข 7 และ 8 ตัว

[talayphuket]

เรียน อาจารย์ snasui และผู้รู้ทุกท่าน

ต้องการสูตรการสลับตัวเลขของเลข 7 ตัว และ เลข 8 ตัว (เพราะสูตรที่คิดได้ทำได้ถึงแค่เลข 6 ตัว) ตามไฟล์แนบ

[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

[talayphuket]

เรียน คุณnorkaz

สูตรที่ให้มาใช้ได้ตามต้องการครับ

ขอบพระคุณอย่างสูงครับ