8BallRunOut

u/8BallRunOut



r/ottawa•

Lost wallet

Lost/Found

I lost my wallet yesterday and you tried to return it to my house this morning but my Mother-In-Law told you i don't live at the address on my driver's license 🤬. If that sounds like you, please DM me.

82

r/askcarguys•

I'm getting quotes to have a hitch installed on my 2023 Corolla Hybrid LE and the manufacturers guarantee their hitches are compatible with the 2022 version. Is it safe to assume it will be compatible with the 2023 version? Also, if a manufacturer states a hitch is compatible with the "2023 Corolla" does that mean it's going to work on all models & trims?

10


After scouring the internet for a tool to calculate my 2021 capital gains, I noticed there was a gap in this regard. While searching on the internet, all the tools I found were extremely simple, for example: a purchase of 100 shares of xyz for $10 each, followed by a sale of 100 shares for $15 each. That simple example certainly didn't describe my stock trading history this year, so I decided to make my own tool to calculate capital gains from the sale of stock and crypto transactions.

The spreadsheet should work for all Canadians - capital gains are capital gains no matter where you live

2726

r/excel•

I'm trying to make a clearAll() function inside my UserForm which sets all the fields on the various MultiPages equal to "".

I have 4 fields on 7 pages of one MultiPage all named "cboCategory1", "cboArea2", etc...

So essentially, I'm wondering if I can turn these 28 lines of code into something more efficient.

​

Private Sub clearAllFields()
    Me.cboCategory1 = ""
    Me.cboArea1 = ""
    Me.txtDetails1 = ""
    Me.cboType1 = ""
    Me.cboCategory2 = ""
    Me.cboArea2 = ""
    Me.txtDetails2 = ""
    Me.cboType2 = ""
    Me.cboCategory3 = ""
    Me.cboArea3 = ""
    Me.txtDetails3 = ""
    Me.cboType3 = ""
    Me.cboCat
35

r/billiards•

I have this person on my team who's been playing pool for over 20 years and is still a 3 - sometimes a 2 (the lowest handicap). A couple teammates and I are getting pretty tired of carrying this person and I decided to kick them off after this league is over. Got any tips on being less of a dick about it?

745

r/excel•

I have the following code

x=Evaluate("=SUMPRODUCT(--(Candidates[First Name]=" & Me.cboFirstName & "),--(Candidates[Last Name]=" & Me.cboLastName & "),Candidates[CandidateNum])")

which always results in Error 2029 regardless of if there is a match in the data set or not. I should add that on hover, Me.cboFirstName = "John" and Me.cboLastName = "Smith"

Then I tried

x=Evaluate("=SUMPRODUCT(--(Candidates[First Name]=""John""),--(Candidates[Last Name]=""Smith""),Candidates[CandidateNum])")

Which does work, so what am I doing wrong?

24

r/Cooking•

Hello again r/Cooking!

last week I posted (https://www.reddit.com/r/Cooking/comments/6k2frw/monthly_meal_plan_spreadsheet/) this spreadsheet on here to share with you all in case anyone found it as useful as I do. In this updated version, you are able to select the number of days you'll be having a particular meal as leftover's - this will tell Excel to simply repeat that meal for x number of days in the meal planner. Next, you are able to select the first day in the calendar for the meals to start generating, so if you wanted to plan for a week carrying over into next month, you can totally do that now. I've also integrated a grocery list feature that will not double count the 'leftover'

61

r/Cooking•

Hello r/Cooking!

I made this spreadsheet to organize my meals for the month (though I'm currently using it as a bi-weekly planner). My girlfriend doesn't like eating the same thing over and over again, so we usually make something different every night and then have it for lunch the next day.

Here's how it works.

  • Enter the month and year of interest.
  • Click "Randomize Meals" button on left.
  • The macro will automatically insert random meals from the other sheet and hyperlink to the correct website (if there is a link at all).
  • I've set it up so that no two meals are the same, though you can totally go and change a particular meal on any day to whatever you want using the drop down p
6812

r/excel•

I have a pretty trivial problem that should be relatively easy to solve, but I just can't seem to get it right. I've inherited this workbook that has data laid out very weirdly. I have a row with both text data and numeric data and I'd like to return the left-most text cell above every numeric cell. For example, I have...

Book1 | 1 2 | Book2 | 3 4 5 6 7 | Book3 | 8 9 10 |

And I'd like to get "Book1" above the 1 and 2 cells, "Book2" above the 3,4,5,6, and 7 cells, and "Book3" above the 8,9, and 10 cells. *Note: the range here is always changing, new columns will be inserted regularly thus changing the numeric entries.

I'm open to a UDF as well since it's already macro-enabled.

Thanks in a

01

r/Guelph•

Hello Reddit,

My girlfriend is looking to join a womens hiking group. If one doesn't exist then she'd also like to gauge interest on starting her own, so if you'd be interested, please post below. By the way, she's 24 and a student at UoG. Thank you!

38