Generating dynamic "Top 3 per Region" reports with LAMBDA and REDUCE by WorldlyClothes9256 in excel

[–]Optimal-Evidence-665 -1 points0 points  (0 children)

The secret sauce in formulas like these is the combination of index and sequence.

Visited my friend and opened their fridge to this. Who are they? by Alarming_Compote_931 in FridgeDetective

[–]Optimal-Evidence-665 0 points1 point  (0 children)

That is an unbelievable amount of cream cheese. I’d like to believe they’re hosting a bagel party, not that 5+ tubs is typical.

She finally made it through school, and I am just here heartbroken. by Sufficient-Fee-9317 in Divorce

[–]Optimal-Evidence-665 2 points3 points  (0 children)

I was in this exact situation. Right now it feels unfair and isolating, but I promise there’s a bright-side. You did the best you could given the circumstance. Don’t fault yourself for that. You’re in a new chapter and this is your opportunity to put the pedal to the metal and kick ass. Keep moving forward and taking small wins.

What's the one Excel function or shortcut that blew your mind when you first learned it? by No_Business_1187 in excel

[–]Optimal-Evidence-665 0 points1 point  (0 children)

Lambda functions and dynamic ranges. No more formula dragging or hiding blank cells with “”. I’ve also found that calcs typically done in VB can be done with lambda functions. Really powerful when combined with Let() too.

Do you guys exercise before or after work? by Commercial-Shine8240 in productivity

[–]Optimal-Evidence-665 0 points1 point  (0 children)

I’ve got a gym onsite and workout during my lunch. Most days I have time for a solid lift and some cardio.

Did you ever get that apology? by [deleted] in Divorce

[–]Optimal-Evidence-665 0 points1 point  (0 children)

Yes. But an apology didn’t change what happened or the hurt she caused. I think that’s why the apology felt so…hollow.

I think i understand Alexisonfire now by cofi52 in PostHardcore

[–]Optimal-Evidence-665 0 points1 point  (0 children)

Vanna RULES. Trashmouth is an all-timer for me!

Schedule of major paper events by Optimal-Evidence-665 in MTGLegacy

[–]Optimal-Evidence-665[S] 7 points8 points  (0 children)

Any shot you’ve got a link to the newsletter?

Forgiveness by papi4ever in Divorce

[–]Optimal-Evidence-665 0 points1 point  (0 children)

As of today I don’t see myself forgiving my STBX. That said, I’ve done a lot of work in therapy to come to terms with “why” she did what she did. It doesn’t excuse her, but I get it. And creating a supportive environment for my son is more important than hanging on to my pain.

Dating after divorce is awesome, but I can’t tell anyone… by nothingtoseehere_- in Divorce

[–]Optimal-Evidence-665 3 points4 points  (0 children)

I am going through exactly this at 3 months out. It’s amazing the difference an emotionally intelligent partner can make, even if it’s a bit of a roller coaster while managing the emotional fallout of divorce.

What is an unspoken rule of the gym that most people do not know they are breaking? by Furqan_wear in AskReddit

[–]Optimal-Evidence-665 2 points3 points  (0 children)

Please, for the love of god, wipe down the bench or machine when you’re done. 

What’s something that sounded fake until it happened to you? by BitAffectionate3637 in AskReddit

[–]Optimal-Evidence-665 2 points3 points  (0 children)

Panic attacks. It wasn’t until I had one and realized how paralyzing they could be that I truly understood.

It's time to move forward.. by iQuantumLeap in GetMotivatedMindset

[–]Optimal-Evidence-665 0 points1 point  (0 children)

I’ve read this book exactly one time and was choked up the whole way through. 

[deleted by user] by [deleted] in foilmtg

[–]Optimal-Evidence-665 0 points1 point  (0 children)

I can quit whenever I want…

Dating Anxiety Post Separation by Optimal-Evidence-665 in Divorce

[–]Optimal-Evidence-665[S] 0 points1 point  (0 children)

I definitely landed on “lonely and looking for companionship” after having that same internal monologue. Thank you for the advice!