User Profile

tomeegee

Brass Contributor

Joined 4 years ago

21 Posts1 Solution

View All Badges

User Widgets

Recent Discussions

Frustrated 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.
Solved
Apr 22, 2022 Place Excel
Excel
Formulas and Functions
office 365
2.3KViews
0likes
5Comments
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 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.6
Solved
Oct 25, 2021 Place Excel
Excel
Excel on Mac
Formulas and Functions
3.7KViews
0likes
20Comments
IFS 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?
Solved
Mar 19, 2021 Place Excel
Excel
Excel on Mac
Formulas and Functions
789Views
0likes
2Comments
Teams Mac App No Calendar do I need Outlook
No clear answer in any discussion. I'm a Mac user, up-to-date OS. Have a Teams login. MS365 account. I do NOT use or even have Outlook installed on computer. Is that why there is no calendar on my Teams app? I get invited to teams meeting. They are in my Google Calendar and iCal. When I click on link to join, I get sent back to a "sign up for teams" loop. I open my Teams app and there's no place to paste the invite. There's no calendar for it to be clicked on etc. So I don't get to attend meeting.
Feb 11, 2021 Place Microsoft Teams
Meetings
microsoft teams
4.1KViews
0likes
4Comments

Groups

Recent Blog Articles

No content to show