Create Bingo card by Excel Formula No VBA

[@hangc10]

question; if you save it and the next time around when you open excel; will the number jump to a different number?

[@ExcelWizard]

The numbers in columns B:F will change, Numbers from column I to the ringh remain the same.

[@TechTinkTronics]

Wow, I never thought of making a Bingo card. Thanks for sharing!

[@ExcelWizard]

Thanks 😊

[@Lala-jw3ov]

Amazing job!!
I going to do this as a project. I just have one question, can I put the formulas in another sheet? or hide them in some way or another?

[@ExcelWizard]

No. Please keep the formula, then copy, paste the value to another sheet.

[@erictayetaye5591]

do you how to make cards but with words, not numbers ?

[@antoniusaleksander9160]

Bisa ga di buatkan kartu 1-75 sebanyak 96 pcs kartu

[@agnesvaldenaro]

Thank you so much!

[@aajtarr]

Awesome!! ty so much for this!!!

[@ExcelWizard]

I'm glad you like it 😍

[@Jen.live9]

สามารถสุ่มเป็นตัวหนังสือได้ไหมค่ะ

[@ExcelWizard]

ได้ครับ
อยากได้แบบไหน ทำตัวอย่างไปถามในกลุ่มนะครับ
facebook.com/groups/ExcelSuperFan

[@retusf7782]

ถ้าอยากให้เป็น 1-50 ทำยังไงครับผม

[@ExcelWizard]

B2
=RANK(B9,B$9:B$23)+10*(COLUMNS($B2:B2)-1)

[@retusf7782]

@@ExcelWizard ขอบคุณครับ

[@nooral7282]

How can I do this with texts?

[@ExcelWizard]

Please provide some text samples and post your question at
facebook.com/groups/ExcelSuperFan/

[@nooral7282]

@@ExcelWizard for example (baby shower bingo): rattle, sheets,baby hat, car seat, play,bib,changing pad, etc....