Excelguru.ca - Powered by vBulletin
  • Register
  • Help

  • Home
  • Products & Services
    • Live Training
    • Video Courses
    • Monkey Tools Add-in
    • Books & Other Products
    • Private Courses
    • Consulting & Mentoring
    • Training Calendar
    • Affiliate Sales Program
    • About Us
    • Today's Posts
    • FAQ
    • Calendar
    • Community
      • Member List
    • Forum Actions
      • Mark Forums Read
    • Quick Links
      • View Site Leaders
  • Blog
  • Forum
    • Excelguru Forums
    • What's New?
    • Today's Posts
    • Forum Guide
    • Forum FAQ
    • Supported BB Code Tags
  • Resources
    • Online Training
    • Recommended Books
    • Add-ins & Tools
    • Excel Blogs
    • Useful Links
  • Knowledge Base
  • Contact Us
  • Advanced Search
  • Home
  • Home
  • Knowledge Base Articles

  1. If this is your first visit, then welcome! Be sure to check out the FAQ by clicking the link above.
    Register here so that you can post in the forums or comment on the articles.

  • Monkey Tools
  • Knowledge Base Articles By Category

    Access - ADO (4)
    Access - SQL (4)
    Access - VBA Programming (10)
    Downloads - Games (1)
    Downloads - Learning Aids (11)
    Downloads - Utilities (9)
    Excel - ADO (4)
    Excel - Charts and Data Visualization (1)
    Excel - Formulas (8)
    Excel - General Tips (36)
    Excel - Interactive Pages (9)
    Excel - PivotTables (12)
    Excel - Power Query (3)
    Excel - PowerPivot (7)
    Excel - SQL (4)
    Excel - UDF (7)
    Excel - User Interface Customization (2)
    Excel - VBA Programming (49)
    Excel - WebApp (4)
    Internet Explorer - VBA Programming (1)
    Novell Groupwise - VBA Programming (2)
    Other - General (1)
    Outlook - General Tips (5)
    Outlook - VBA Programming (7)
    PDF Creator - VBA Programming (11)
    Power BI (3)
    PowerPoint - VBA Programming (7)
    Publisher - VBA Programming (7)
    Syndicated Articles (7)
    Training Products (10)
    Word - VBA Programming (8)
  • Downloads - Games

    Excel Blackjack Game 

    by
    Ken Puls
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • Visit Homepage
    • View Articles
    Published on 2010-11-15 08:57 PM     Number of Views: 31633 

    Just for fun, I decided that I would build a game in Excel, so here's my version of Blackjack.

    Features:
    The rules are pretty standard Blackjack rules... adjust your bet, then hit Deal. You get two cards, the dealer gets one up, one face down. You can hit or stay, and the hand will unfold for you.
    ...
    Read More Read More
  • MVP Logo
  • Recent Forum Posts

    AliGW

    can a pivot table show my data in the way i need it?

    I'm just down the road from you!!!

    Can you please mock up a few rows of data showing how you want it to look?...

    AliGW Yesterday, 05:02 PM Go to last post
    rantanwang

    can a pivot table show my data in the way i need it?

    hi i have an energy readings spreadhseet populated by ms forms responses. i need to get the meters as rows and then the monthly readings as columns to...

    rantanwang Yesterday, 04:25 PM Go to last post
    AliGW

    Conditionally filling a table based on non-unique information from another table

    Just for completeness, this would be an AND lookup:

    =IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($A$1:$A$13)/(($C$1:$C$13="Production")*($D$1:$D$13="Forward")),ROWS($1:1))),"")...

    AliGW 2021-04-11, 03:35 PM Go to last post
    Joecam

    Conditionally filling a table based on non-unique information from another table

    Yep, that did it! Thank you so much, it works amazing!...

    Joecam 2021-04-11, 03:21 PM Go to last post
    AliGW

    Conditionally filling a table based on non-unique information from another table

    Maybe this?

    =IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($A$1:$A$13)/(($C$1:$C$13="Production")+($C$1:$C$13="Something Else")),ROWS($1:1))),"")...

    AliGW 2021-04-11, 03:00 PM Go to last post
  • Contact Us
  • Excelguru Forums
  • Archive
  • Top
All times are GMT +1. The time now is 12:15 AM.
Powered by vBulletin® Version 4.2.5
Copyright © 2021 vBulletin Solutions Inc. All rights reserved.
Pre-Defined Posts provided by Post Templates v1.6.1pl1 (Free) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
Thread / Post Bookmarks provided by Thread / Post Bookmarking v1.2.0 (Free) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
Copyright © 2004 - by Excelguru Consulting Inc.
Gravatar by 1e2.it