Wull, it fired right up and did everything right at 0° F, which pleased me.
weds gfmt
- Thread starter stevew
- Start date
it's never too late to repent
The newer the motor vehicle or bicycle, the less useful.
my wife's PHEV minivan is pretty useful
save for lack of AWD. one must choose PHEV or AWD. can't have both
You got 6 more!
‹‹‹‹‹‹‹‹ Hangover Monday GTM ……………………
Was out having beers and drinks last night so I have a hangover today taking full advantage of my vacation!
ridemonkey.bikemag.com
I saw a giant blue jeep the other day and thought of youYou got 6 more!
‹‹‹‹‹‹‹‹ Hangover Monday GTM ……………………
Was out having beers and drinks last night so I have a hangover today taking full advantage of my vacation!
4 more payments til I own it. I could be convinced to move it after that, likely for a CCSB F250 gas.
However, given current interest rates and inventories it's unlikely. I have no desire for a $59K truck.
Last edited:
I had to put the tire socks on the minivan coming through Central City during a storm last year
they worked fine, clearly adding traction over the Nokians already on it
but putting on anything on tires in the middle of a storm bad enough to necessitate them is a huge pain in the ass that I would much rather not repeat, not to mention then being limited to 30 mph etc etc
Excel question. @mandown I'm trying to aggregate 2-4 lines and I can't figure it out. There is a data point specific to an individual who owns 2-4 lines of data (column A). They then have a value that I need to aggregate (column B; rows 2-4 maybe, it's variable). So I need to aggregate the column B data for the individual identified in column A. Any ideas? And I can't use a macro.
clearly
I mean, I wasn't going forward up the hill before they were on
then I was going forward afterwards
qed
clearly
Thanks. I think I needed to clarify that. I have about 500 identifiers on the sheet. So I need to aggregate per identifier.
I hate doing pivot tables.
Your loss. Pivot tables and charts fucking rule. Best way to easily deal with large data sets.
there’s always powerquery
I think the suggestion for SumIf is the way to go. Create a column with a “rolling total” field and set the if criteria to sum the preceding cumulative value with each row’s individual value based on “if” the identifier matches the row above it.
if identifier in row 2 matches row 1 then sum the values. If not, only bring in the value in row 2. Rinse and repeat.
This assumes the dataset is sorted by identifier. I believe the screenshot jbp posted uses a formula that does a SumIf applied to the entire column of identifiers, meaning ordering/sorting wouldn’t matter.there’s always powerquery
I think the suggestion for SumIf is the way to go. Create a column with a “rolling total” field and set the if criteria to sum the preceding cumulative value with each row’s individual value based on “if” the identifier matches the row above it.
if identifier in row 2 matches row 1 then sum the values. If not, only bring in the value in row 2. Rinse and repeat.
Got it. Thank you!
I also need something simple enough that I can pass along the instructions to the rest of my team. JBP got me sorted out in a dummy proof way.
Cut the red wire.
and when that's rated to bumper tow/5th wheel/gooseneck a solid 20k you're truly set unless you're trying to start your own car hauling business or the like
Going to add airbags and a winch, doesn’t need much
I'd happily swap for a Godzilla equipped truck. I'd be sad to lose the exhaust brake, but so be it.
You no longer need to bang your head with Pivot tables.
Try Xlookup
XLOOKUP function - Microsoft Support
Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from...
support.microsoft.com
How is it different from VLOOKUP?You no longer need to bang your head with Pivot tables.
Try Xlookup
XLOOKUP function - Microsoft Support
Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from...
I won’t own another tier 2 or higher diesel again I’m afraid, owned them all and they all had the recipes to make them bulletproof but the EPA has pretty much shut all of that down to the point of no return. Thus far the Godzilla has been to be cheaper on fuel, maintenance and is exempt to EPA’s reach as of now.
It's external and I don't even know when it actually starts or how long it lasts. We're a heavily regulated industry and are constantly under various audits. They are all just blurred together to me. I'll get requests with due dates, I'll respond, rinse, repeat.
That's my biggest concern long term. DEF and fuel filters are NBD, more expensive than a gasser sure but not prohibitively so. It's the EGR cooler, DPF, and SCR systems that are all big ticket items cost wise, nevermind finding a tech with the knowledge to work on them.
There's a good reason a lot of fleets have switched over to gas. Diesel engines may in theory have a longevity benefit, the systems required to meet today's emissions standards not so much.
same as me. our audits are usually a weeklong. multiple times a year from various notified bodies.
It's a frozen tundra outside and the wife thinks Abbey will shit in the house. She has gone outside, but her dog has not and we know how full of shit he is.
Forgot about that. Good call. But can you sum values in multiple rows or only retrieve a single value?You no longer need to bang your head with Pivot tables.
Try Xlookup
XLOOKUP function - Microsoft Support
Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from...
Edit - won't work for the requested project.
Syntax
The XLOOKUP function searches a range or an array, and then returns the item corresponding to the first match it finds. If no match exists, then XLOOKUP can return the closest (approximate) match.
Last edited:
- XLOOKUP can look for values to the left and right of the lookup array, while VLOOKUP is limited to only looking for values to the right of the lookup value column.
- XLOOKUP allows you to customize text when a valid match is not found, while VLOOKUP only shows you an #N/A (error sign).
- XLOOKUP allows you to specify a search mode (such as starting to look from the top or the bottom of a table) while VLOOKUP can only start looking for values from the top.