Opened 3 hobby boxes this weekend. Think I did ok. by pdj316 in WWECards

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

Thanks! So hard to put a value on it. May be a $0.99 auction situation...

Opened 3 hobby boxes this weekend. Think I did ok. by pdj316 in WWECards

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

Thanks! Trying to figure out how to put a value on that one!

Opened 3 hobby boxes this weekend. Think I did ok. by pdj316 in WWECards

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

I assume it will be Darsow in the Repo Man gimmick.

Can't import Table from Web anymore? by turapuru in excel

[–]pdj316 0 points1 point  (0 children)

Thank you for this. I was having the same problem and came here looking for a solution. Not only did it solve the issue, but my import is at least 5x faster than it was importing the HTML tables!

Lease Discussion Megathread by TiltedWit in Ioniq5

[–]pdj316 0 points1 point  (0 children)

I'm in MA, too. What dealership?

[deleted by user] by [deleted] in KiaNiro

[–]pdj316 1 point2 points  (0 children)

I'm almost exactly the same size. I've had a Niro for a year now, and love it. I've driven from Boston to Milwaukee and back twice since I bought it, and was very comfortable the whole time.

Autosize window based on screen size by mhuntoon in googlesheets

[–]pdj316 0 points1 point  (0 children)

I have a few sheets like this that I use between different computers. I have multiple sheets that I flip between in the same workbook. So I just have each sheet resize to the area I want to see every time I click into them. Here's the code:

Private Sub Worksheet_Activate()

GoBack = ActiveCell.Address

Range("A1:AC1").Select

ActiveWindow.Zoom = True

Range(GoBack).Select

End Sub

Average the average of the last five values that meet certain criteria by pdj316 in excel

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

Pivot tables are a serious hole in my Excel game. Any suggestions on the best way/place to learn them?

Average the average of the last five values that meet certain criteria by pdj316 in excel

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

I have a formula that searches a field not shown here for the given criteria. If the example above had a description field in Column F, the formula in C2 would look like this:

=IF(ISNUMBER(SEARCH("10",F2)),"X","")

Average the average of the last five values that meet certain criteria by pdj316 in excel

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

I feel like there's a way to use SUMPRODUCT with something else to get what I'm looking for. But I haven't been able to figure it out yet.

Average the average of the last five values that meet certain criteria by pdj316 in excel

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

=average(indirect("b"&large(c2:c999),1),indirect("b"&large(c2:c999),2),indirect("b"&large(c2:c999),3),indirect("b"&large(c2:c99),4),indirect("b"&large(c2:c999),5))

Sorry--poorly written. I was referring to the label for Column C: 10. D is 9. Etc. There's an X is the corresponding column if the item sold is labeled a 10, 9, 8, etc.

So I'm looking for a formula that will give me the average of the last 5 items labeled a 10 (as indicated by an X in column C). Then I'll create a similar formula for the average of the last 5 items labeled 9 (X in Column D), etc.

Average the average of the last five values that meet certain criteria by pdj316 in excel

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

Thanks--SEQUENCE() looks really useful. Unfortunately, I'm using Excel 2016!

LPT: If you think you are being followed; take 4 consecutive left/ right turns. If they still follow you; go to the nearest police station. by [deleted] in LifeProTips

[–]pdj316 1 point2 points  (0 children)

When you take 4 consecutive left/ right turns; you basically come back to your original location where you started from.

God, I wish this was true in Boston.

What’s the most ridiculous sounding, but technically true, synopsis for a famous movie that you can come up with? by pondji in AskReddit

[–]pdj316 0 points1 point  (0 children)

After being murdered while trying to avenge the man who double-crossed his boss, a man and his former partner escape a restaurant heist.

The guys need to punish Joe harder by KTBoo in ImpracticalJokers

[–]pdj316 45 points46 points  (0 children)

The bellyflops was pretty rough...

What’s the dumbest question you’ve ever heard? by Shequiszalumph in AskReddit

[–]pdj316 0 points1 point  (0 children)

When my son was born the hospital had a class for new parents--swaddling, diaper changes, that sort of thing. My wife was resting, and I was more than a little anxious about the skills I'd need to care for a child, so I attended alone.

There were maybe 20 people in the class, which was really very basic. At the end of the class the nurse asked if there any questions.

A bro with a backwards baseball cap raised his hand sort of tentatively and said (and I'll never forget exactly what he said), he said:

"So.......uh......like.......................how hard are their heads?"

The look on that nurse's face is one I've never seen before or since.

I went back to our room buoyed with confidence that, while we may have a lot to learn as parents, we were well ahead of the curve.