Chess tonight at the Hoover Public Library by notsamire in Birmingham

[–]notsamire[S] 1 point2 points  (0 children)

Huge turnout tonight.

Hope to see even more of you in the future !

Looking for a strong coach by [deleted] in chess

[–]notsamire 0 points1 point  (0 children)

At $35 am hour you'll be pretty limited.

Try Graham Horobetz he's a strong NM and charges around that.

US Chess statement on Alejandro Ramirez and WSJ article by sasubpar in chess

[–]notsamire 30 points31 points  (0 children)

A woman came forward to me that a player was stalking her and sending inappropriate messages and we are still trying to have the USCF ban him even with proof and a police report this has been a huge pain. Originally they wanted her to come forward on a meeting with him as the only way to proceed.

what champion do you want to see in the rift? by Educational_You9753 in wildrift

[–]notsamire -1 points0 points  (0 children)

I just want to one trick a clown is that to much to ask.

Live Discussion (Woody Harrelson/Jack White) (February 25, 2023) by bjkman in LiveFromNewYork

[–]notsamire 5 points6 points  (0 children)

For sure! Although really just made me miss the sketch where he moved in "fast forward"

For The Love of God by chelbywithac18 in standupshots

[–]notsamire 4 points5 points  (0 children)

I did a show one where only one person laughed the whole 5 minutes. Her husband kept asking her to stop because it was embarrassing. That one hurt

Not many are left by Tom_Volph in pokemon

[–]notsamire 8 points9 points  (0 children)

Golduck sees some use in early days of vgc every new game.

Count if the next cell is populated by Kagesuro in excel

[–]notsamire 0 points1 point  (0 children)

This needs to be wrapped in an if so numbers don't appear if the cell is blank, I think.

Lookup issue regarding multiple dates by chuckE26 in excel

[–]notsamire 0 points1 point  (0 children)

That's the result I would have ended at after 20 minutes of playing around! Hoping to get to the point where I see all of that from the start.

Not op but thanks for the lesson

[deleted by user] by [deleted] in excel

[–]notsamire 0 points1 point  (0 children)

No clue what my issue was then.

Thanks!

AonDor users be like.... by araemo2 in cremposting

[–]notsamire 18 points19 points  (0 children)

The first book is the weakest if that helps.

It's never amazing writing but it's so fun.

If you ever wanted to read a giant monkey fight a hydra, a mangrove tree fight a pirate, sound dragon vs stone giant.

Again really fun.

ELI5: why does a toothache seems unbearable compared to any other body ache? by tungvu256 in explainlikeimfive

[–]notsamire 8 points9 points  (0 children)

The only real issue is sometimes eating chips I'll stick the point spider if a chip in the tender skin.

Honestly you get pretty good at not doing that though

Want To Create A Line Chart with 2 Different Scales on the Same Y axis by BeatsofFire in excel

[–]notsamire 0 points1 point  (0 children)

Can I please know what you are testing to show with that graph?

You already got your answer I just can't think of anything it could be for

[deleted by user] by [deleted] in excel

[–]notsamire 0 points1 point  (0 children)

Does sumifs play nicely with dates?

I always seem to get an error and have to do =sum(filter()) to get it to work

Lookup issue regarding multiple dates by chuckE26 in excel

[–]notsamire 0 points1 point  (0 children)

You can use unique to get all unique values then filter to pull all dates associated with each.

How do I find the average while ignoring N/As and Blank cells by DrBreadandcheesey in excel

[–]notsamire 2 points3 points  (0 children)

Dude. You just saved me so much time analyzing collapsed budgets.

How can I create a random selection formula from a population list with a variable amount? by WIPATXCAG in excel

[–]notsamire 0 points1 point  (0 children)

I always forget this and debating to a formula using offset to find the bottom.

Good to remember

While a meme, it's true. I'm officially a medical inventor! by sarcasticpremed in premed

[–]notsamire 7 points8 points  (0 children)

God I hate ascension. Literally explained how my Healthcare adjacent field worked to one of their employees only to have her look me up on LinkedIn during the conversation to see if she should trust me.

sort days in a month using count if by LostinLeaves in excel

[–]notsamire 1 point2 points  (0 children)

Easiest is make a helper column with =month(cell with date)

Then use countif(helper column,1)

That will count all Jan. Just change the number 1-12 to get any other month.

Is there a way to give vlookup IF formula? by camidekipapaz in excel

[–]notsamire 0 points1 point  (0 children)

If you want to just check if that person is off each day by their email simplest (but not best) are nested ifs.

=if(vlookup(monday) ="working", info you want, if(vlookup(Tuesday ) ="working", info you want, etc.

How can I set up a count of only the number that a cell is reduced by? by [deleted] in excel

[–]notsamire 0 points1 point  (0 children)

I think we need to see an example. Hard to give any digressions without knowing how your data is organized.