- Видео 1
- Просмотров 53 090
Joseph Kataquapit
Добавлен 21 дек 2016
How to make a Bingo card using Excel
Bingo Card using Random number formula on excel.
Three main formulas used to make this card are the =Large, =Rand and =Vlookup formulas. There are other ways to formulate the card but i find it easier using these three.
Three main formulas used to make this card are the =Large, =Rand and =Vlookup formulas. There are other ways to formulate the card but i find it easier using these three.
Просмотров: 53 102
Thanks a million! I have not been able to figure out how to get rid of duplicates in my bingo card, but this has solved it. I used this for a Bingo card with words, and it worked well.
I can seetm this video ending up on some asmr channel
How would I print multiple pages at once?
hello, I have this formula but its says its not correct? can you tell me what I am doing wrong please
Thank you so much for the step by step instructions. Out of all the videos I have watched this one help ed me out the most. :) Thank you again.
I LOVE THIS. Not sure why some of the steps did not work for me but i figured it out.
Very clear and usefull, Thank's Joseph 🙂
I started off well, but when the first error of N/A appeared and was fixed, \i found it difficult to understand the instructions of what was happening, why it was happening and how to rectify it. I'm sure others will understand. Thanks for the video.
Or use: =INDEX(UNIQUE(RANDARRAY(5^3; 1; 1; 25; TRUE)); SEQUENCE(5;5)) 1; 25; TRUE) 1=starting number, 25 = ending number (1-25) SEQUENCE(5;5)), 5 rows, 5 columns.
This is brilliant, thanks
I NEED 5 ROWS 1-15 16-30 31-46 61-75 I HAVE TO SHUFLE THE,M ROW BY ROW IT WOULD MAKE IT EASY FOR MEE TO JUS PRESS ENTER OR f9
Great programming... Can you try to code TAMBOLA which is Indian Bingo?
Great ! Thanks !
What if I wanted to have a bingo sheet using all 15 lines? instead of just 5... i can get to 8 lines maximum!
MEE TOOO IT WONT LE5T GO PAST 7 OR 8 NEED IT FOR BOMBO I HAVE TO SHUFFLE ROW BY ROW
let's see if this video actually works
Great video! Thanks
large function doesn't work how come
was a little different in office.org. got repeating numbers, but very helpful. Thank you taking the time to make this video.
it is a liey not telling the true
Good Morning Excellent spreadsheet Sir would have an email to contact. I would like to ask you for help. Thank you for now