Forum Discussion

tomeegee's avatar
tomeegee
Brass Contributor
Oct 25, 2021
Solved

Shorter way or shortcut to use IF, AND, AND drawing from 3 variables

I have a scoresheet spreadsheet I've developed. I have 12 players playing 5 courses and each course you could be playing FRONT or BACK. Each player has a unique number associated with their name, the...
excel
Excel on Mac
Formulas and Functions
  • tomeegee's avatar
    tomeegee
    Oct 27, 2021
    I'm very impressed by this formula! I am tooling around with it to expand it to all courses and when the formula is on separate worksheets etc. But you've given me a great tool to work with! Thanks.
tomeegee's avatar
tomeegee
Brass Contributor
Oct 26, 2021
Thanks QP. I need to unpack this, but it looks like an answer! Be back later.
tomeegee's avatar
tomeegee
Brass Contributor
Oct 26, 2021
Wow that works well. I'll start dissecting to learn what it's doing and integrate it into my workbook. Thanks a ton! I might have a question or two...