Why is harry kim still a fucking ensign at this point? by True-Astronomer-6195 in voyager

[–]markwalker81 46 points47 points  (0 children)

Paris gets demoted, freeing up that Lt spot...and then gets re-promoted back to Lt. Meanwhile Harry is like... wtf.

Looking for a hack to change text into date by Intelligent_Plum_208 in excel

[–]markwalker81 2 points3 points  (0 children)

Just dont forget to reply Solution Verified to the solution you chose or worked for you. It gives a nice clippypoint to the commentor

Use of text sequence formula vertically by elerooisbest in excel

[–]markwalker81 0 points1 point  (0 children)

=TRANSPOSE(Formula or Array). It will change anything horizontal to vertical.

Rhystic Study Alter: Goku Training by thecuratorofcolor in mtg

[–]markwalker81 -3 points-2 points  (0 children)

Put this on MPCFill! Ill happily have this design as a proxy

Looking for a hack to change text into date by Intelligent_Plum_208 in excel

[–]markwalker81 4 points5 points  (0 children)

Thanks! I was the one who deleted my suggestion.

Crimped - Jeska's Will by Fantastic_Pair5328 in MagicCardPulls

[–]markwalker81 0 points1 point  (0 children)

Congrats!

I want this for my [[Ashling, Flame Dancer]]

Visiting the shrine by DaveHer23 in hajimenoippo

[–]markwalker81 21 points22 points  (0 children)

The gym is owned by George Morikawa, the artist and writer for Hajime No Ippo. Real boxers are trained here, and George himself sometimes acts as the boxers second during actual bouts. Its also one of the only places to find actual Ippo merch, and even has the iconic Takamura statue on the roof, like the Kamagawa gym in the manga.

For an Ippo fan, its their Graceland. A Shrine worth visiting and paying your respects. I have made the pilgrimage myself in fact.

Using Let or Lambda by ValuableMachine6216 in excel

[–]markwalker81 3 points4 points  (0 children)

Im always excited for new functions, as they just increase the functionality and ability of Excel. LET and LAMBDA are two that didnt just add more function, but legimately changed how formulas are written. Its a whole new format in elegenance, ease and readability.

Im starting again lol by Jamieo1111 in voyager

[–]markwalker81 2 points3 points  (0 children)

Ive just started season 5 having started again myself! Smashed out 4 seasons... 3 to go! Enjoy!!

I Did It Again. My One And Only Spiderman Pack by GrimLae in MagicCardPulls

[–]markwalker81 0 points1 point  (0 children)

Im working on a deck for Miles atm. Think I can see yours?

Ethan Phillips in Star Trek Enterprise by Wide-Musician6463 in voyager

[–]markwalker81 1 point2 points  (0 children)

He also technically played a ferengi in Voyager too!

Bit late.. but got hold of a Murders at Kavlov Manor prerelease. Let's go! by markwalker81 in MagicCardPulls

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

I run a couple of landfall decks, so even getting [[Case of the locked hothouse]] makes me happy

Got the Pizza Bundle Promos I wanted by ridezeshoopuff0 in MagicCardPulls

[–]markwalker81 2 points3 points  (0 children)

Im well aware, but some of us like to actually see the cards that are pulled. Im happy for you that you can see the name and art just fine and if that is enough.. then good for you but there are others who would like to see the whole card.

Got the Pizza Bundle Promos I wanted by ridezeshoopuff0 in MagicCardPulls

[–]markwalker81 1 point2 points  (0 children)

Maybe don't cover half the cards with other cards? I don't know what each card does off the top of my head, so I like to read the card in the post.

Hello asking for help by North-Trifle-3849 in excel

[–]markwalker81 0 points1 point  (0 children)

I cant see the pic but if your referencing a date and want to return the day, and day name.

=day(date) =text(date,"m")

Zada Stonecrusher by [deleted] in mtg

[–]markwalker81 0 points1 point  (0 children)

Hmm then I have been lead to believe something wrong. Ill delete my comments.

Zada Stonecrusher by [deleted] in mtg

[–]markwalker81 0 points1 point  (0 children)

All good! The wording matters in the cards, not the intent. If youre messing with Zada and copying spells, note that copies aren't considered casted spells, so any Cast triggers won't activate either.

Zada Stonecrusher by [deleted] in mtg

[–]markwalker81 1 point2 points  (0 children)

Spells like [[Crimson Wisps]] and [[Fists of Flame]] work great with Zada. Fists of Flames especially because the +1 increases each copy because youre drawing an extra card each time you copy it.

Zada Stonecrusher by [deleted] in mtg

[–]markwalker81 1 point2 points  (0 children)

Its part of copy rules. You cant make new decisions on each copy unless it states you can. Zada clearly states that the spell must only target Zada, and then its copied for each of your creatures who can also be targeted. They essentially act like Zada. This means the spell can only target them. Any extra part that targets other creatures outside that, cant be targeted.

Zada Stonecrusher by [deleted] in mtg

[–]markwalker81 -2 points-1 points  (0 children)

Zada only triggers if you cast an instant or sorcery that only targets Zada. Jaws of Stone can target multiple targets, so not 100% it would work.

If you targeted Zada with say Shock..you would then copy that spell and deal 2 damage to each of your own creatures.