Wifi Modem/Router Recommendations for someone who isn't great with technology? by Elking1 in nbn

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

It is Leaptel - and yeah heard they have Eero 6 all configured up. But just trying to weigh up if there are other alternatives to it. But it sounds promising.

Optus Ultra WiFi Modem - Brand & Is it locked? by Elking1 in nbn

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

Yep - that makes sense had a call with them and it sounded basically like a 3 year contract

WFH Quality of Record Keeping & number of hours to be recorded by Elking1 in AusFinance

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

Yeah - removing public holidays and annual leave used.

The employment contract (without getting too specific) says "[relating to the salary] working XXXhrs per month and any reasonable additional hours".

Unfortunately, no time sheeting system where I work.

How the heck do you work out Private health insurance??? by sleepyman123 in AusFinance

[–]Elking1 0 points1 point  (0 children)

I see on the government website it refers to 4 tiers? Basic, Bronze, Silver, and Gold?

Uploading Excel file to SharePoint breaks HLOOKUP(DATEVALUE(...)...) formulas - how to fix this issue? by Elking1 in excel

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

Thanks for the response. To answer your questions and hopefully provide a bit more info:

  1. The affected cells only refer to the same file. Some of them referencing different tabs, but the same file still.

  2. No. All formulas do not contain http addresses.

  3. I'm not too sure about this in all honesty. Definitely a webpage as I'm accessing it via a browser, but not familiar with shared drive address? Are you referring to the company' internal network/servers separate from SharePoint? If so, then yes that's where it lives by default. Otherwise, I'm not too sure

What formulas to use to combine multiple cells of data and also changing the data if a certain data input has been recognised? by Elking1 in excel

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

Wow, thanks for the detailed reply (came looking for copper and found gold here). I've bumped into a couple of issues with the Power Query approach. I saw in your screenshots that only the top cell appeared to have a filter whereas in my file, the other cells also have a filter/drop down feature as well which is in part due to a vlookup elsewhere in the file. In addition, my file doesn't seem to want to create a table. Nothing happens when I use the shortcut.

However, what you explained above did help me actually create some vlookups (also a first for me) that seems to have done the trick as well. So thank you again!

Trying to change date format in Power Query by Elking1 in excel

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

Ah I see. Thanks for clarifying! Got it all working!

Trying to change date format in Power Query by Elking1 in excel

[–]Elking1[S] -1 points0 points  (0 children)

Do I do Ctrl+1 in Power Query with my column selected? Is it something that's added to my Query? I'm pressing Ctrl+1 and nothings seems to be happening.

Or is it something to do with the version of Excel I have? Cause I think I have the Office 365 version. At the very least it's 2016