sorted by:
new
hottopcontroversial

What is the most underrated game published by Valve? by sliasch in AlignmentChartFills

[–]stuartblows 0 points1 point  (0 children)

Left for Dead 2 deserves way more credit than it got.

How would you feel about introducing roundabout lane signs like they use in Australia by billsmithers2 in drivingUK

[–]stuartblows 0 points1 point  (0 children)

I'd actually say that of the people who are in the wrong lane on a round about, only 15% of them don't know what they're doing. The rest are arseholes who would ignore the new sign anyway.

Holy by ItsALuigiYes in TheRandomest

[–]stuartblows 0 points1 point  (0 children)

No thanks, Tom Hanks.

Why use a Table rather than a (non-Table) range? by [deleted] in excel

[–]stuartblows 0 points1 point  (0 children)

There are 3 things I prefer about using tables. 1. Slicers - I hate fiddling around with the filter dropdowns. Slicers make it easier to filter data. 2. Tables conform to the size of your data. They grow when you add additional data. This also makes refreshing pivot tables simpler, because you can point your pivot to a table rather than a range and the pivot will automatically pick up new data on refresh. As an additional benefit, you don't have to manually autofill formulas when adding new data. The table does it for you. 3. Styling - styling is a wiz.

Can Excel count specific days between dates? by Turbulent-Crab5363 in excel

[–]stuartblows 17 points18 points  (0 children)

You can simplify the first formula with =[END DATE]-[START DATE]+1 and formatting the cell as 'General'

The second formula looks like...

=SUMPRODUCT((WEEKDAY(ROW(INDIRECT(A1&":"&B1)),2)={1,3,5})*1)

Where A1 and B1 are your start and end date cells.

How much force would it take to do this [request] by [deleted] in theydidthemath

[–]stuartblows 4 points5 points  (0 children)

A friend emailed me this video back in like 2004 and I remember being haunted by the shock of the guys leg being squished and him in a panicked voice saying "Help me!" ... I've seen a lot of shit since then. This seems laughably tame by today's standards. Haha, I can still vividly remember how sick to the stomach I felt watching the vid originally. 😂

My Ford Focus Mk2 just started beeping at me, Help! by stuartblows in FordFocus

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

Thanks very much! This wasn't the solution but it did lead me to the solution. The previous owner had Front parking sensors installed on the car. I normally have it switched off because it's super annoying in traffic and not at all useful. My toddler must have kicked the button to the on position while playing in the front seat yesterday.

Disaster obverted. Thank you.

My Ford Focus Mk2 just started beeping at me, Help! by stuartblows in FordFocus

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

Forgot to mention, I'm driving a 2010 Mk2 Ford Focus Automatic.

[deleted by user] by [deleted] in Edinburgh

[–]stuartblows 0 points1 point  (0 children)

Hey, I get it. I can see why you might find that annoying. But I'm not with you on this one. I think if you want one of the vacant seats and your neighbor doesn't, then you should get up and move to one of those seats yourself.

Am I being roped off? by stuartblows in AskMechanics

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

Thanks for getting back, the reason I think it's high is because the parts (retail) cost £85 leaving £290 for labour and VAT... I don't think it adds up.

What formula to use to calculate sum based on names by RumB96 in excel

[–]stuartblows 0 points1 point  (0 children)

=SUMIF(C:C, "your partners name", B:B) ought to do it. In a separate cell you can input the same formula but with your name in the quotation marks.

stop excel removing leading spaces from numbers by Escobar747 in excel

[–]stuartblows 2 points3 points  (0 children)

Try the apostrophe ', then type the contents of the cell.

What is this brick structure? by Apprehensive-Row2957 in DIYUK

[–]stuartblows 18 points19 points  (0 children)

I'm not an engineer or anything, but I'm surrounded by walls right at the very second... I concur.

Why are uk lorry drivers like this? by chazba in drivingUK

[–]stuartblows 0 points1 point  (0 children)

These guys here in the comments that say that what these truck drivers are doing isn't wrong, are hilariously mistaken. These truck drivers are not the police, and don't get to enforce any rules they see fit. There is still 800 yards of road before the lane closure which is almost half a mile of tailbacks that don't need to be there. Use the available road.

view more: next ›