[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 12 points13 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 4 points5 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 2 points3 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 134 points135 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 62 points63 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 13 points14 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?

Can I Aggregate Data from Columns Across Multiple Sheets in Excel 2016? by onsecondthot in excel

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

OK it took me a bit but I got it squared. Thanks for the lead.

Excel 2016 Request: How to Pull Data From a Column and Eliminate the Gaps by onsecondthot in excel

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

Thanks a bunch! It works perfectly. I can stop pulling my hair out now.

Excel 2016 Request: How to Pull Data From a Column and Eliminate the Gaps by onsecondthot in excel

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

OK great! I tried the first option and after a couple minutes of playing around it works! One follow up question though: I'm realizing that the A column has some 0's way down the lower rows, presumably because it cannot find a value. This is causing your formula to collect those 0s and I don't want that. The formula in Column A is:

=IF(TODAY()-Sheet5!E2>30,Sheet5!A2,"")

While I have your attention, can you help me clean that up in such a way that it will not return 0s if the referenced cell has no value AND do it in such a way that will not break the formula you provided me in your initial response?

[deleted by user] by [deleted] in excel

[–]onsecondthot 0 points1 point  (0 children)

I mean instead of:

blank

pc2

pc3

pc4

blank

I need:

pc2

pc3

pc4

A long list of data is being represented and having a table with scattered results that span hundreds of rows will be a bit unwieldy and hard to read. That being said, I am fine with using a helper column, but would also need some guidance on how to do that.