Page 1 of 1

สุ่มอักษรภาษาไทย ยกเว้นบางอักษร

Posted: Wed Jan 10, 2018 3:30 pm
by blenoppadol
เรียนท่านผู้รู้ทุกท่าน

ต้องการเขียนสูตรสุ่มอักษรภาษาไทย
ซึ่งสูตรนี้เขียนว่า =CHAR(RANDBETWEEN(161,206))

แต่ถ้าหากต้องการ Random ไม่ให้พบอักษร ได้แก่ ฆ,ณ,ฌ,ญ,ฎ,ฏ,ฑ,ฒ,ษ,ฬ
เขียนสูตรอย่างไรครับ

ขอบคุณครับ

Re: สุ่มอักษรภาษาไทย ยกเว้นบางอักษร

Posted: Wed Jan 10, 2018 5:25 pm
by puriwutpokin
ลองดูนะครับว่าได้ไหม
=CHOOSE(RANDBETWEEN(1,36),"ก","ข","ฃ","ค","ฅ","ง","จ","ฉ","ช","ซ","ฐ","ด","ต","ถ","ท","ธ","น","บ","ป","ผ","ฝ","พ","ฟ","ภ","ม","ย","ร","ฤ","ล","ฦ","ว","ศ","ส","ห","อ","ฮ")

Re: สุ่มอักษรภาษาไทย ยกเว้นบางอักษร

Posted: Thu Jan 11, 2018 8:37 am
by blenoppadol
เรียน คุณ puriwutpokin

ขอบคุณครับผม
ลองทดสอบดูแล้วได้ผลตามที่ต้องการครับ

Re: สุ่มอักษรภาษาไทย ยกเว้นบางอักษร

Posted: Sat Apr 01, 2023 6:52 pm
by R-K@-PI
puriwutpokin wrote: Wed Jan 10, 2018 5:25 pm ลองดูนะครับว่าได้ไหม
=CHOOSE(RANDBETWEEN(1,36),"ก","ข","ฃ","ค","ฅ","ง","จ","ฉ","ช","ซ","ฐ","ด","ต","ถ","ท","ธ","น","บ","ป","ผ","ฝ","พ","ฟ","ภ","ม","ย","ร","ฤ","ล","ฦ","ว","ศ","ส","ห","อ","ฮ")
แล้วถ้าเป็นแบบ 4 หลักจะเขียนสูตรยังไงครับ ขอขอบคุณล่วงหน้าครับ[

Re: สุ่มอักษรภาษาไทย ยกเว้นบางอักษร

Posted: Sat Apr 01, 2023 7:51 pm
by puriwutpokin
=CHOOSE(RANDBETWEEN(1,36),"ก","ข","ฃ","ค","ฅ","ง","จ","ฉ","ช","ซ","ฐ","ด","ต","ถ","ท","ธ","น","บ","ป","ผ","ฝ","พ","ฟ","ภ","ม","ย","ร","ฤ","ล","ฦ","ว","ศ","ส","ห","อ","ฮ")&CHOOSE(RANDBETWEEN(1,36),"ก","ข","ฃ","ค","ฅ","ง","จ","ฉ","ช","ซ","ฐ","ด","ต","ถ","ท","ธ","น","บ","ป","ผ","ฝ","พ","ฟ","ภ","ม","ย","ร","ฤ","ล","ฦ","ว","ศ","ส","ห","อ","ฮ")&CHOOSE(RANDBETWEEN(1,36),"ก","ข","ฃ","ค","ฅ","ง","จ","ฉ","ช","ซ","ฐ","ด","ต","ถ","ท","ธ","น","บ","ป","ผ","ฝ","พ","ฟ","ภ","ม","ย","ร","ฤ","ล","ฦ","ว","ศ","ส","ห","อ","ฮ")&CHOOSE(RANDBETWEEN(1,36),"ก","ข","ฃ","ค","ฅ","ง","จ","ฉ","ช","ซ","ฐ","ด","ต","ถ","ท","ธ","น","บ","ป","ผ","ฝ","พ","ฟ","ภ","ม","ย","ร","ฤ","ล","ฦ","ว","ศ","ส","ห","อ","ฮ")

Re: สุ่มอักษรภาษาไทย ยกเว้นบางอักษร

Posted: Wed Apr 05, 2023 1:55 pm
by R-K@-PI
puriwutpokin wrote: Sat Apr 01, 2023 7:51 pm =CHOOSE(RANDBETWEEN(1,36),"ก","ข","ฃ","ค","ฅ","ง","จ","ฉ","ช","ซ","ฐ","ด","ต","ถ","ท","ธ","น","บ","ป","ผ","ฝ","พ","ฟ","ภ","ม","ย","ร","ฤ","ล","ฦ","ว","ศ","ส","ห","อ","ฮ")&CHOOSE(RANDBETWEEN(1,36),"ก","ข","ฃ","ค","ฅ","ง","จ","ฉ","ช","ซ","ฐ","ด","ต","ถ","ท","ธ","น","บ","ป","ผ","ฝ","พ","ฟ","ภ","ม","ย","ร","ฤ","ล","ฦ","ว","ศ","ส","ห","อ","ฮ")&CHOOSE(RANDBETWEEN(1,36),"ก","ข","ฃ","ค","ฅ","ง","จ","ฉ","ช","ซ","ฐ","ด","ต","ถ","ท","ธ","น","บ","ป","ผ","ฝ","พ","ฟ","ภ","ม","ย","ร","ฤ","ล","ฦ","ว","ศ","ส","ห","อ","ฮ")&CHOOSE(RANDBETWEEN(1,36),"ก","ข","ฃ","ค","ฅ","ง","จ","ฉ","ช","ซ","ฐ","ด","ต","ถ","ท","ธ","น","บ","ป","ผ","ฝ","พ","ฟ","ภ","ม","ย","ร","ฤ","ล","ฦ","ว","ศ","ส","ห","อ","ฮ")
อันนี้คือใช้สูตรเดิม 4 ครั้ง โดยใช้ & เป็นตัวเชื่อมใช่ไหมครับ ลองแล้วได้ 4 ตัวอักษรตามต้องการครับ ขอขอบคุณครับผม