Joseph Kataquapit
Joseph Kataquapit
  • Видео 1
  • Просмотров 53 090
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.
Просмотров: 53 102

Видео

Комментарии

  • @lesleybramhill
    @lesleybramhill 2 месяца назад

    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.

  • @Dannyboy0202
    @Dannyboy0202 8 месяцев назад

    I can seetm this video ending up on some asmr channel

  • @lucii9867
    @lucii9867 11 месяцев назад

    How would I print multiple pages at once?

  • @ElnazSadoughianzadeh
    @ElnazSadoughianzadeh Год назад

    hello, I have this formula but its says its not correct? can you tell me what I am doing wrong please

  • @DawnChatham-r3c
    @DawnChatham-r3c Год назад

    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.

  • @mandycoronado3309
    @mandycoronado3309 Год назад

    I LOVE THIS. Not sure why some of the steps did not work for me but i figured it out.

  • @julies9524
    @julies9524 2 года назад

    Very clear and usefull, Thank's Joseph 🙂

  • @yourbeautiful8080
    @yourbeautiful8080 2 года назад

    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.

  • @flotyrmunken
    @flotyrmunken 3 года назад

    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.

    • @hayashikin
      @hayashikin 2 года назад

      This is brilliant, thanks

    • @Allie8062
      @Allie8062 5 месяцев назад

      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

  • @hemantjshah
    @hemantjshah 3 года назад

    Great programming... Can you try to code TAMBOLA which is Indian Bingo?

  • @kinderwithmsmaninder
    @kinderwithmsmaninder 3 года назад

    Great ! Thanks !

  • @lyreco1983
    @lyreco1983 3 года назад

    What if I wanted to have a bingo sheet using all 15 lines? instead of just 5... i can get to 8 lines maximum!

    • @Allie8062
      @Allie8062 5 месяцев назад

      MEE TOOO IT WONT LE5T GO PAST 7 OR 8 NEED IT FOR BOMBO I HAVE TO SHUFFLE ROW BY ROW

  • @TheVishalgodha
    @TheVishalgodha 4 года назад

    let's see if this video actually works

  • @chesterman92
    @chesterman92 4 года назад

    Great video! Thanks

  • @arnolddy6534
    @arnolddy6534 6 лет назад

    large function doesn't work how come

  • @gabym.3627
    @gabym.3627 7 лет назад

    was a little different in office.org. got repeating numbers, but very helpful. Thank you taking the time to make this video.

  • @ernestohernandez5356
    @ernestohernandez5356 7 лет назад

    it is a liey not telling the true

  • @canino37
    @canino37 7 лет назад

    Good Morning Excellent spreadsheet Sir would have an email to contact. I would like to ask you for help. Thank you for now