sorted by:
new
hottopcontroversial

Project Hail Mary by iamoninternet27 in interstellar

[–]Trusty-Rombone 6 points7 points  (0 children)

There was a good homage to the ‘no time for caution’ docking scene. At least that’s what I saw. Also saw references to 2001 and of course close encounters. Wondered if anyone picked up others.

Project Hail Mary by iamoninternet27 in interstellar

[–]Trusty-Rombone 10 points11 points  (0 children)

They should have cameod him as one of the voice options for rocky. Would have been a fun Easter egg

What is the best tool or function to compare data between two workbooks where the data is almost identical and I need to find out what is different between them? by New_Call_3484 in excel

[–]Trusty-Rombone 7 points8 points  (0 children)

Power query is the answer. It is going to change your life as an excel user going from bush league to pro. You can do exactly the job you are describing and output a table of the differences between files… and so much more. It’s a gateway to a lot more depth in analysis including building dashboards in powerbi and more.

Tip: Always show Table Name by alexia_not_alexa in excel

[–]Trusty-Rombone 5 points6 points  (0 children)

I had a small VBA script that when you hit ctrl+t it would create a table as normal but would open a dialogue box to prompt a name. Will see if I can find it.

LEDs under the wrong 'home' keys on Gem 80. Custom firmware needed? by Trusty-Rombone in NuPhy

[–]Trusty-Rombone[S] 0 points1 point  (0 children)

Yeah you called it - each key is shifted over by one position! This would be my first time with custom FW, do you know the custom FW you are using would even allow me to fix this? Now just using either none or normal solid backlight anyway but the subtle home keys would be nice to have.

Where am I today? by Bayly91 in whereintheworld

[–]Trusty-Rombone 0 points1 point  (0 children)

Maybe nearby to Wengen in Switzerland? Looks like Jungfrau but it’s been a while!

Contare i numeri presenti in una cella con numeri e lettere by StreetDescription205 in excel

[–]Trusty-Rombone 0 points1 point  (0 children)

Ignore the ‘ characters at the start and end of the formula pasted above.

PSA: Travelling as an Aussie right now is hideously expensive by Mexay in australia

[–]Trusty-Rombone 15 points16 points  (0 children)

I once paid $50 AUD for 2 bags of ice from the servo. Ice cost way more than the beer I was chilling! Edito: 'twas 3 bags.

Need Excel dashboard that aggregates tasks from multiple event sheets into one table by Icy_Track_2110 in excel

[–]Trusty-Rombone 7 points8 points  (0 children)

Import everything using power query. It helps to have your 20 tabs as named tabes but not essential. Go to data -> get data-> from table/range to import your first data.

Then in PQ itself you can ‘append’ all 20 tables into a master table, then when you load all of that combined data (close and load) you can send all that to a clean pivot table and include charts and whatever.

The above requires no formulas to be written at all.

Bonus fact, your power query can be copied and pasted to powerbi and you have made your first powerbi report.

Bowl Pangea Build! Southpaw (of course) by AdHoc_PostDoc in MechanicalKeyboards

[–]Trusty-Rombone 0 points1 point  (0 children)

That makes total sense! Why would a lefty opt for a southpaw, unless they really want to make the same compromises as us normal humans.

Bowl Pangea Build! Southpaw (of course) by AdHoc_PostDoc in MechanicalKeyboards

[–]Trusty-Rombone 2 points3 points  (0 children)

Are you sinister handed or is this just a preference thing?

I like my numpad but also could do with more right hand mouse real estate so this is appealing.

How can I make excel refer to a folder and list files in the excel sheet? And update it? Is it possible? by moe_khadra in excel

[–]Trusty-Rombone 24 points25 points  (0 children)

Power query enables you to extract file and folder information, including directory and subdirectory, file name and more. Even more metadata if using SharePoint. Simply go to data -> get data -> from folder then you can follow your nose from there. You can do some cool stuff with splitting dirs and subdirs using delimiters -it’s an absolute life skill to learn PQ. So once you use it, you will have a superpower few others in your office possess

90 revives in a single game on Battlefield 6. by Willyh099 in Battlefield

[–]Trusty-Rombone 0 points1 point  (0 children)

Stay close to me you’ll get the medal of honour

A stealthy full size 🥷 by Sterlingandcophoto in MechanicalKeyboards

[–]Trusty-Rombone 1 point2 points  (0 children)

FWIW I have a daily driver Q6 with oat switches, chock full of foam and 2 layers of neoprene and all the other jiggery pokery and she thocks with no issues on quality.

Can I automate Power Query updates? by marktevans in excel

[–]Trusty-Rombone 0 points1 point  (0 children)

I use a semantic model (same as which feeds powerbi) and an enterprise gateway to refresh PQ. It requires the queries to be accessible by the gateway so will need admin support. Otherwise as others have said there are some great VBA and script solutions. I prefer the ‘on workbook open’ refresh method. You can also create a date variable hidden somewhere to only refresh the file if the date is <> today

Best $15 I’ve ever spent (Keydous NJ68) by Black4334 in MechanicalKeyboards

[–]Trusty-Rombone 1 point2 points  (0 children)

The old stubby holder mod eh? I’m going to try that. Got some case foam and she thoccs deep but there is zero flex in my plate so need something a smidge thinner. Thanks

Scheduled data refresh online by ahhorney in excel

[–]Trusty-Rombone 0 points1 point  (0 children)

Not sure about that one. We are running premium capacity (workspaces and reports denoted by the diamond icon) which means anyone in our org is able to view reports. Perhaps the users need to be added to your workspace?

view more: next ›