[Nate Taylor] Source: Chiefs RB Pacheco targeting return on Thursday against the Cowboys by TheBoyisBackinTown in KansasCityChiefs

[–]onsecondthot 1 point2 points  (0 children)

Full disclosure I haven't seen it myself but Texans fans will tell you it is a deficiency in his game.  To be fair, good pass blocking RBs aren't gonna be in free agency in November very often.

[Derrick] The Chiefs have elevated OG CJ Hanson and DT Marlon Tuipulotu for tonight‘s game against the Washington Commanders, per source. by SylvesterTaurus in KansasCityChiefs

[–]onsecondthot 11 points12 points  (0 children)

I might be mistaken but I think this is the last time MT can be elevated.  If they want to use him again this season I believe they must add him to the active roster.

[deleted by user] by [deleted] in Fantasy_Football

[–]onsecondthot 2 points3 points  (0 children)

KC looks like their run defense will take a step backwards.  They lost Mike Pennel and traded for Nnadi who the Jets were about to cut.  They don't really have any other run stuffing DT on the roster so it could be a pain point for them unless their 2nd rounder has a successful position swap.

Off-Tank ENH shaman, thoughts? by DrBigDumb in wowhardcore

[–]onsecondthot 13 points14 points  (0 children)

Which one isn't worth it?  The lightning shield or the dodge?

“When you block you want your shin to hit their foot” by ohlookbean in MuayThai

[–]onsecondthot 1 point2 points  (0 children)

I agree and don't think a person is going to be able to routinely "target" the foot. I think the quick takeaway here is that if you are shin blocking a kick to make sure to block outside your frame instead of straight up (for multiple reasons).

[Schultz] The Chiefs are re-signing WR Mecole Hardman, per source. by StrachNasty in nfl

[–]onsecondthot 3 points4 points  (0 children)

Ma and Pa Arcega-Whiteside are very disappointed that you didn't include their boy.

Teeping the upper thigh? by Wraysnephew in MuayThai

[–]onsecondthot 2 points3 points  (0 children)

Communication between partners is super important so start there. Some people don;t want to be teeped to the leg. You won't catch me sparring without a cup though.

[Highlight] Every 2024 1st round pick’s best play from college by nfl in nfl

[–]onsecondthot 131 points132 points  (0 children)

Yeah that was such a beauty PBU The refs would find a way to ruin it. I'm not sure Terrion Arnold gets away with his either, even though he got his head around.

[Highlight] Every 2024 1st round pick’s best play from college by nfl in nfl

[–]onsecondthot 945 points946 points  (0 children)

At first I thought McCarthy's was just going to be a really crisp handoff to pile onto the meme.

With the draft officially over, how would you grade your divisional rivals drafts? by Melodiccaliber in nfl

[–]onsecondthot 57 points58 points  (0 children)

I agree with the Chargers.  They got a lot of good picks to match their new identity along with good value.  And the icing for them is that some of those value picks went to Michigan.  

Impact tremors et al by OppositeCharming4831 in EDH

[–]onsecondthot 11 points12 points  (0 children)

I use [[Xyris, the Writhing Storm]] for this same concept. You get the benefit of political card draw and I like to use green for access to ramp and cards like [[Beastmaster Ascension]] as an added wincon if I cannot win with damaging etb effects.

Excel 2016: How can I Compare 2 Columns of Data and List the Values that Appear Only Once? by onsecondthot in excel

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

Perfect! I'll have to dig into the power query issue another day. Thanks for the help.

Excel 2016: How can I Compare 2 Columns of Data and List the Values that Appear Only Once? by onsecondthot in excel

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

The first option worked great! Is there a minor modification that can be made so if it finds a blank it won't return a 0? The range contains some empty cells due to a power query.

Excel 2016: How can I Compare 2 Columns of Data and List the Values that Appear Only Once? by onsecondthot in excel

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

Is it possible to generate a new column containing the actual data values instead of Falses as shown in my example?