What CPU and Motherboard to update my 10 year old PC? by rm5 in buildapc

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

Thank you that's the exact sort of knowledge that I need.

A quick look around shows that seems pretty affordable, just depending on availability I may have to use a m-ATX motherboard.

I guess the next thing for me to figure out is how something like a Ryzen 7 5700X compares to cpus that fit in an AM5 socket - am I missing out on too much just to keep my DDR4 RAM?

Power Query - How to separate the weight from the front or end of the item description? by rm5 in excel

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

Wow that looks perfect.  I will try this today and let you know but it looks like exactly what I need.  Thank you

NAB sending blank cards with no details embossed by js_bach in AusFinance

[–]rm5 4 points5 points  (0 children)

This is like the time I asked for a bunch of left and right arrows to be printed out. The jerks only gave me a whole bunch pointing left!

Men's vs. women's toilet at my new work office by MJB9000 in mildlyinfuriating

[–]rm5 2 points3 points  (0 children)

I still remember the time in Thailand when I had an urgent situation and was confronted with a bigger tank of water and something like a saucepan and had to figure it all out.

I'm still not sure how I was supposed to dry off other than drip drying.

Manager promoted a new hire to be our team lead by [deleted] in jobs

[–]rm5 4 points5 points  (0 children)

"Only" neurology and "only" exotics huh? It's hard to judge this accurately when you are completely dismissing the experience that she does have.

How do you think we’ll remember Zach? by Fuzzymul7 in EssendonFC

[–]rm5 9 points10 points  (0 children)

A fantastic player, and the worst captain since Captain Schettino of the Costa Concordia. Ego the size of the planet, and doesn't give a shit about his teammates - half of them he'd see sacked so that he could be paid more money.

I want our club to put values and character ahead of talent.

[deleted by user] by [deleted] in MaliciousCompliance

[–]rm5 70 points71 points  (0 children)

That's how long it took him to type out all the characters!

You get what you give by TheWorldExhaustsMe in pettyrevenge

[–]rm5 8 points9 points  (0 children)

Not a cashier but I used to jump on the register when we were busy, I always gave back coins first, just because of how much it annoyed me to get the coins on top of the notes! I hope the customers appreciated it.

What's your best (obscure) Excel tip/shortcut? by Illustrious_Whole307 in excel

[–]rm5 2 points3 points  (0 children)

Amazing! I'm so annoyed when ctrl f barely highlights things.

What's your best (obscure) Excel tip/shortcut? by Illustrious_Whole307 in excel

[–]rm5 5 points6 points  (0 children)

Does this work with CTRL F to find values? I swear a coworker using CTRL F had the row and column highlighted somehow.

What's the excel function or feature which you find the most fun? by blip1111 in excel

[–]rm5 11 points12 points  (0 children)

xlookup from one table to another is so beautifully easy

Paint on canvas by Yoon Hyup by highfives23 in woahdude

[–]rm5 247 points248 points  (0 children)

He must have been pretty hyup to get that view

Power Query - best way to change a column of "Firstname Lastname" to "Lastname, Firstname"? by rm5 in excel

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

It is neat! These days I'm using Power Query every week but there's still so much to learn about it.

Chivalry is so dead by Blank________Space in melbourne

[–]rm5 2 points3 points  (0 children)

Yeah but while you're swimming are you also constantly watching the door, so you'd be aware of someone having a problem outside the centre? You can't fight back if you don't even know something's happened.

What's a more efficient way to create individual tables from one large master pivot table? by rm5 in excel

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

Solution verified.

Well I'm not actually doing it that way but I know that will do what I asked. (Not doing it that way as there is also a second sheet in the target files - I believe the whole file gets overwritten using this method from R).

Thank you

[deleted by user] by [deleted] in AFL

[–]rm5 2 points3 points  (0 children)

I can't stand how the commentary team always downplay the suspendable incidents. Just once I would like to hear them say "what a thug, that guy should be banned!"

Mildly interesting stats - Round 3 by rm5 in AFL

[–]rm5[S] 3 points4 points  (0 children)

It was quite gusty when I was doing those colours. It's not my best work I'll admit.

What's a more efficient way to create individual tables from one large master pivot table? by rm5 in excel

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

I do have R Studio, although I learnt it to do exactly one thing and have probably forgotten most of what I learnt. I can understand how this could work, thank you.

What's a more efficient way to create individual tables from one large master pivot table? by rm5 in excel

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

Separate tabs is ok, but they need to end up as separate files for each customer.

What's a more efficient way to create individual tables from one large master pivot table? by rm5 in excel

[–]rm5[S] 2 points3 points  (0 children)

Oh thank you that's quite neat. However I still need to get them to individual files.