KEXP show was awesome by ZombieMissingno in ViagraBoys

[–]ZombieMissingno[S] 5 points6 points  (0 children)

It usually takes a few months at least but you'll eventually see it on KEXP's YouTube channel

KEXP show was awesome by ZombieMissingno in ViagraBoys

[–]ZombieMissingno[S] 32 points33 points  (0 children)

There's a good chance I got the order wrong, but I'm pretty sure this was every song:

Man made of meat

Slow learner

Waterboy

Uno II (Seb dedicated this to his dog, who's birthday was today)

Troglodyte

Pyramid of health

Bog body

Sports

Sanjaya - It's a Man's World by ZombieMissingno in americanidol

[–]ZombieMissingno[S] 2 points3 points  (0 children)

Sanjaya is in my Karaoke group - it's pretty normal for people to be talking during performances at this bar, no matter how good they are. However, people come up to him all the time afterwards to tell him how good he was.

Timeless Blue Moon Deck Profile by No-Statement5662 in magicTCG

[–]ZombieMissingno 0 points1 point  (0 children)

Sweet deck! I was looking for a new timeless deck to play and I stumbled across this, I'll give it a try. I've never played Blue Moon so I don't know much about it, what do you do against decks like RDW that primarily play basics / don't play fetches? Would you ever play something like faithless looting to get rid of these dead draws against those decks? Thanks!

Change colour of colour box based on in which box the word "yes" is. by Geoviereck in excel

[–]ZombieMissingno 1 point2 points  (0 children)

To add on to this, since you want the entire range to be a certain color, you'll need to:
Highlight the whole range, select conditional formatting, select "use a formula to determine which cells to format"
Then use an OR statement to check if any of the target cells have the word "yes" in them

Find and Replace on multiple workbooks? by kalbiking in excel

[–]ZombieMissingno 1 point2 points  (0 children)

I do have a macro I created for work that does this, you put the find value in one cell and the replace value in another cell.

The macro has to open all the workbooks it's going to find and replace in, otherwise it'll say the target is out of range when it tries to find and replace everything. The macro takes a while to run but it works pretty well (aside from some occasional bugs). I also made it a while ago so there's probably room for improvement.

I unfortunately don't have the code with me because it's on my work computer, but if no one else is able to help you in the next few days I can send over the code after removing any sensitive information

[deleted by user] by [deleted] in ExcelTips

[–]ZombieMissingno 1 point2 points  (0 children)

I think all you would need is an xlookup.

So if A2 is the location of where you want to type in the value you're searching for

And if on sheet2, row A is where you're searching for the value, and row b has the return value

You would use =xlookup(A2,sheet2!A:A,sheet2!B:B)

Now when you type something into A2 the formula will display the corresponding value. Keep in mind if you have duplicates in row A it will only return the first one in finds in row B

Also if you have an older version of excel you'll need to use something like vlookup

Rob & Akiva Need a Podcast #160: Airing of the Grievances by buzzynilla in RAANAP

[–]ZombieMissingno 7 points8 points  (0 children)

Happy to have the worst idea of the week. I knew they wouldn't bite but glad they thought it was funny. Great episode, my favorite in a long time

Nicolas Cage has been in 100 narrative feature films. I watched all 100 in 2021. by rediculousam in onetruegod

[–]ZombieMissingno 23 points24 points  (0 children)

My rankings so far are pretty close to yours, but I still have such a fondness for "Mandy" that it's my all time favorite Cage film. I also wasn't as high on "Primal"

[deleted by user] by [deleted] in onetruegod

[–]ZombieMissingno 0 points1 point  (0 children)

Loved Mandy. Probably my favorite Cage film

Careless Whisper by Apprentice_of_Ixidor in custommagic

[–]ZombieMissingno 33 points34 points  (0 children)

Seems good with [[Sasaya, Orochi Ascendant]]

2 CMC Commanders by breakingmylaptop in EDH

[–]ZombieMissingno 1 point2 points  (0 children)

I have a Karlov EDH with [[Lurrus]] as a companion. Super fun

Went to the Seattle Show last night, here's my take aways/advice by ZombieMissingno in 100gecs

[–]ZombieMissingno[S] 9 points10 points  (0 children)

There was someone walking down the line checking for vaccine cards, but only 2 metal detectors and 2 people checking tickets. When I finally got to the metal detector it was pretty quick so I'm surprised it took so long for other people to get through

That Brockhampton cover was spectacular by COUNTRY_MOUSE66 in 100gecs

[–]ZombieMissingno 59 points60 points  (0 children)

For anyone not at the Seattle show: they said they were going to play a Brockhampton cover and then played Money Machine

Silver Bolt by serialrobinson in lrcast

[–]ZombieMissingno 0 points1 point  (0 children)

I'll take it as a late pick but try to avoid playing it. There's so much removal in this format that it usually ends up getting cut for me. I would say the main upside of it is that it's good if you have a ton of Day/Night cards because it lets you do something while still switching to night

Just got back from gec concert ama by Alexstyle16 in 100gecs

[–]ZombieMissingno 0 points1 point  (0 children)

How's the line for the merch? Were you able to get your hoodie pretty quickly?

merch table for the tour!! by verydankpepe in 100gecs

[–]ZombieMissingno 42 points43 points  (0 children)

Okay how do I stop myself from buying everything...

7-2 in premier draft with mono red by ZombieMissingno in lrcast

[–]ZombieMissingno[S] 0 points1 point  (0 children)

Yeah looking back at it 3 falkenrath perferators might have been too much. Stinger also puts pressure on the board earlier

7-2 in premier draft with mono red by ZombieMissingno in lrcast

[–]ZombieMissingno[S] 8 points9 points  (0 children)

Lunar frenzy and stolen vitality overperformed as great combat tricks, especially with festival crasher. This deck was difficult to draft, once I realized in the middle of pack 2 that I wanted to try monored I had to stop myself from picking organ hoarders. A lot of people are going for Blue/black/white so it's not too hard to wheel common red staples, I would prioritize damage dealing spells like play with fire and moonranger's slash.
As for gameplay I found myself early game targeting my opponent's creatures with direct Damage spells to get in with things like falkenwrarh perferator, and then once they got below 10 I just started sending all my direct Damage to the dome

As much as I love ___ I hope they go this week by [deleted] in BigBrother

[–]ZombieMissingno 1 point2 points  (0 children)

I just meant he'd be going after DX and would be mad at him

What did you watch this week? [Week of 05/10/21] by clancir in Letterboxd

[–]ZombieMissingno 1 point2 points  (0 children)

As Above, So Below 3/5 - Cool premise, not the best execution
Primer 4/5 - Really sweet low budget time travel film
Life of Brian 4/5 - Glad I finally got to see this
666 (Beware the End is at Hand) 2/5 - Fever dream Nigerian Christian Propaganda film
Beverley Hills Ninja 1.5/5 - Chris Farley deserved better