User Profile
tomeegee
Brass Contributor
Joined Feb 11, 2021
User Widgets
Recent Discussions
Re: Frustrated making changes to =@INDEX(INDIRECT (Mac 365)
Sergei! I remember you from last year. Thanks for replying. Maybe I'm missing something. I can't find where the "@" is I'm using other than the =@INDEX. I've pasted the array and the @Index from both our files and they appear identical. Yet yours does populate the Score Card Par and Hole Handicap from KingPrince (although it starts at D25/26 and not C25/26, so you can see hole 9 and the total are outta whack). I can't find ParHCPs!$C$25:$U$27 in my NewBook file.2.3KViews0likes3CommentsFrustrated making changes to =@INDEX(INDIRECT (Mac 365)
I have a golf scoring worksheet that I received tremendous help on from this community last year. I've tried my best to learn what I was taught and understand what the formulas are doing so I can make modifications myself without running here with every little thing. But I've hit a wall with =@INDEX(INDIRECT, which is the core of my workbook. On the attached samples, the "Old Book" on worksheet ParHCPs shows the functioning formula used to populate the scorecard par and the hole handicap (this is used throughout the full workbook). On the "New Book" I updated the number of players, reduced the number (and name) of courses (Sheet S22) and on sheet ParHCPs I modified the Array in order to populate the handicaps with and without a woman player. When I do that, the =@INDEX(INDIRECT looses its Reference and I can't understand why. Because of course, I don't understand =@INDEX(INDIRECT and try as I have I can't find a clear video lesson on what's going on here. Any help, advice, pointing to right direction would be greatly appreciated.Solved2.5KViews0likes5CommentsRe: Shorter way or shortcut to use IF, AND, AND drawing from 3 variables
OliverScheurich I am hitting wall on referencing =@INDEX(INDIRECT($I$3),IF($C$3="M",2,3),IF($B$5="FRONT",COLUMN(B1),COLUMN(L1))) on another worksheet. The name of this worksheet is ParHCPs. So I've tried referencing COLUMN(ParHCPs!B1) with broken results. I've been searching, but the other COLUMN formulas are treated differently, and I don't want to pollute what you've done. The other issue is once I've attempted to use the INDEX(INDIRECT on another worksheet and trying to reference, my Lists have all gone wonky and look like this. My biggest fear is breaking everything!696Views0likes0CommentsRe: Shorter way or shortcut to use IF, AND, AND drawing from 3 variables
That's really incredible streamlined! I would imagine if I had more than one woman, I could create a W list and replace Gina M with that sublist? I look forward to applying this tonight to see it action. Thank you!2.7KViews0likes0CommentsRe: Shorter way or shortcut to use IF, AND, AND drawing from 3 variables
Hello again! I have been having a good time applying @Quadruple_Pawn's index formula. I also learned when not to, and just stick with nested IF. Though I did come across this challenge. In the attached spreadsheet, I have a nested IF (in C9) to populate the appropriate hole handicap based on course, and side. However, I have one woman player in my Players list, and the handicaps for her would all be different (except on Sand Hallow). So at the bottom I experimented with a modified IF to include =IF(AND(B3=Player (in C33) so that if any player from the list is in B3, the handicaps populate. And then I duplicated the formula and changed it to =IF(AND(B3="Gina M" (in C34) and have it populating the women's handicap. However, I'm not sure how to have both exist in the same formula without getting into another really, really long nested IF. They're pretty long already. Essentially I'm looking for an IF/BUT sort of thing, if there was one. Or am I getting to crazy for one golfer? I could eventually get more women, so I could have two lists, Mens, Womens. Any help would be great. Is it possible to buy you guys a beer?2.8KViews0likes3CommentsRe: Shorter way or shortcut to use IF, AND, AND drawing from 3 variables
I am so appreciative of all the responses to my inquiry. But QP I just quickly applied your formula to the whole event in minutes! I am curious about Sergia's LET, but for the moment, this formula you've provided is a solid answer to my challenge. Thanks again!2.8KViews0likes0CommentsRe: Shorter way or shortcut to use IF, AND, AND drawing from 3 variables
I have 365 for Mac so it is compatible. Where does the rest of the formula "live"? J3 has "=_xlfn.LET(" in it, but the function works so the rest must be somewhere! I want to play around with expanding this to the full tournament.2.9KViews0likes0CommentsRe: Shorter way or shortcut to use IF, AND, AND drawing from 3 variables
Thanks for that clarification before I disappeared into a VBA rabbit hole! To be clear, a deeply nested IF function is what I am trying to avoid, correct? Quadruple Pawn's formula seems to work pretty well. I just need to now expand it to include all courses and apply across multiple pages of the workbook.2.9KViews0likes2CommentsShorter 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 course, and whether it's front or back. So: =IF(AND(B3="Player 1 Name",I3="Course Name",B5="BACK NINE"),'Course HDCPs'!G12) Works like a charm... for one person. But I want to be able to drop in any name in the Player name field, and swap out the course from a list pull down. I've done this before and my formula is really, really long. For just two players it's: =IF(AND(B22="Player 1 Name",I22="Conestoga",B24="BACK NINE"),'Course HDCPs'!$G$31,IF(AND(B22="Player 2 Name",I22="Conestoga",B24="BACK NINE"),'Course HDCPs'!$G$4)) and so on. So for 12 players... =IF(AND(B3="Player Name" x 12 x 5 courses x Front and Back. Is there a way to shortcut this? Or does Excel not care how many logical tests there are? Way above my pay grade. Excel for Mac. Vers 16.37 running on macOS Big Sur Vers 11.6Solved4.2KViews0likes20CommentsRe: IFS getting #NAME? on Mac Excel V 16.37
HansVogelaar (Smacks head) I figured that out about a minute after I posted. I have a golf tournament spread sheet and the handicaps get applied per person across games, so Name = Specific Course Handicap. This helps me just put in a name and the handicap auto populates. Thanks for the response!855Views0likes0CommentsIFS getting #NAME? on Mac Excel V 16.37
I have a multi worksheet file in which I want to fill two boxes conditionally across workbooks drawing from two lists. When I got #NAME? I thought it was due to long, complicated formula with all the referenced sheets. So I simplified a trial on a blank page, and the result is the same. What am I missing?Solved906Views0likes2CommentsRe: Teams Mac App No Calendar do I need Outlook
I c&p'd the invite into Chrome, same first window as posted. I'm on a mac. The "me" I guess you're referring to is my account icon in the upper right. Signing out just leads me to a sign in or sign up screen. I also tried pasting the invite in the teams search bar and got nothing.4KViews0likes0CommentsRe: Teams Mac App No Calendar do I need Outlook
Thanks StevenC365. I'll run through the process right now and trace the steps. 1. Click on iCal invite from host Get sent to first shared screen. Click on "Already have the Teams App" Launch it now... and get No calendar. No "input meeting ID". No notice that the meeting won't start for another few days (I had to use another meeting in the future, but the result is the same). That's what I get.4KViews0likes2Comments
Recent Blog Articles
No content to show