ฟอรัม Excel, VBA และอื่นๆ ของคนไทยเพื่อประโยชน์ของทุกคนในจักรวาล (Forum Excel, VBA and others of Thai people for everyone in the universe.)
http://snasui.com/
แล้วถ้าเป็นแบบ 4 หลักจะเขียนสูตรยังไงครับ ขอขอบคุณล่วงหน้าครับ[puriwutpokin wrote: Wed Jan 10, 2018 5:25 pm ลองดูนะครับว่าได้ไหม
=CHOOSE(RANDBETWEEN(1,36),"ก","ข","ฃ","ค","ฅ","ง","จ","ฉ","ช","ซ","ฐ","ด","ต","ถ","ท","ธ","น","บ","ป","ผ","ฝ","พ","ฟ","ภ","ม","ย","ร","ฤ","ล","ฦ","ว","ศ","ส","ห","อ","ฮ")
อันนี้คือใช้สูตรเดิม 4 ครั้ง โดยใช้ & เป็นตัวเชื่อมใช่ไหมครับ ลองแล้วได้ 4 ตัวอักษรตามต้องการครับ ขอขอบคุณครับผม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),"ก","ข","ฃ","ค","ฅ","ง","จ","ฉ","ช","ซ","ฐ","ด","ต","ถ","ท","ธ","น","บ","ป","ผ","ฝ","พ","ฟ","ภ","ม","ย","ร","ฤ","ล","ฦ","ว","ศ","ส","ห","อ","ฮ")