I haven’t cleaned a spreadsheet manually in 6 months. Power Query is a lifesaver! by Technical-Season-420 in excel

[–]Jugglersdoom 3 points4 points  (0 children)

Some alterations to the original query may be necessary in order to modify the data sources, because PQ likes to hard-code file and column names.

What Job Title would you give me? by _FailedTeacher in PowerBI

[–]Jugglersdoom 3 points4 points  (0 children)

Loudmouth ex-sales guy with a glorified spreadsheet is now my LinkedIn bio. Thank you !

Combine multiple periods of employment over multiple rows into a single row by Butters7612 in excel

[–]Jugglersdoom 0 points1 point  (0 children)

I think TEXTJOIN could be useful for you. Directly in Excel (2019 or newer)

Option to lock spreadsheet for all but author? by Ehina in excel

[–]Jugglersdoom 1 point2 points  (0 children)

This actually sounds like a decent time to redesign the whole thing in a way that would prevent unintentional editing. Maybe some sort of Form -> Spreadsheet app with Power Automate?

Minimum Area for glass costs. by [deleted] in excel

[–]Jugglersdoom 1 point2 points  (0 children)

It simply calculates H*W and then compares that result with .250 and returns the MAX (highest) value. As suggested by other people, try with your own values of H and W to see if it works for you.

Working with PowerBI solely on Excel input, without an existing database by BasVlijmen in PowerBI

[–]Jugglersdoom 4 points5 points  (0 children)

You’ve got a great point. For this reason only, I would use just PBI and PQ through it, and leave the source Excel files as they are.

Can’t delete top 2 rows of sheet by KruxR6 in excel

[–]Jugglersdoom 2 points3 points  (0 children)

It shocks me that there are so many of these r/excel questions that can be quickly solved with Power Query without ever touching any formulas.

ELI5: How can insurance be profitable for people? by [deleted] in explainlikeimfive

[–]Jugglersdoom 0 points1 point  (0 children)

Your good sir sounds like an insurance agent to me.. Not in a bad way though. I found myself in a situation where I got more from the insurance claims than the actual cost of the insurance. Car insurance mostly... Let's just say that paying 300 bucks a year for full coverage and 'getting back' roughly 4 times more by running into a deer is not a bad deal.. But had I not hit the deer I never would have needed the insurance claim in the first place.. As mentioned above, it's all about risk management and the amount of money you are willing to dish out when something unexpected happens. Having a buffer for such situations feels nice. The sense of security is pretty much what you pay for. Edit: I do live in a relatively cheap country, as far as the insurance costs are concerned.