The power of (2.718)
-
MemphisFlash
- Posts: 2161
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
i would imagine so, those new functions came out in 2018.
-
bigtimesmallshot
- Posts: 20
- Joined: Fri May 24, 2019 9:41 pm
looks great !! - do I need credentials for soccerstats ? - once I click refresh it tries anonymous access but keeps failing ?
-
paspuggie48
- Posts: 634
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
That's nice Memphis..how did you know how to do all this? 
Some won't have Dynamic Arrays for sure, nor the latest version of PQ to operate (depends on their Office Suite subscription). As you know I had some issues with your spreadsheets too.
Still, you're a good student
Some won't have Dynamic Arrays for sure, nor the latest version of PQ to operate (depends on their Office Suite subscription). As you know I had some issues with your spreadsheets too.
Still, you're a good student
-
Archery1969
- Posts: 3217
- Joined: Thu Oct 24, 2019 8:25 am
- Location: Newport
So, i download Office 2019 Professional Plus but it still wont update after Refresh All. 
You do not have the required permissions to view the files attached to this post.
-
paspuggie48
- Posts: 634
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Interesting, it looks like you haven't got Power Query enabled. See my screenshot, albeit it's Office 2016 but there is a Get & Transform section
It may be you have to add it as an add-in; File > Options > Add-ins..... or simply Google it for your Office Suite version.
You do not have the required permissions to view the files attached to this post.
-
MemphisFlash
- Posts: 2161
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
575 views in 24 hours, that must be some kind of record!!!
how long is a piece of string...MemphisFlash wrote: ↑Wed Oct 28, 2020 12:19 pm575 views in 24 hours, that must be some kind of record!!!
-
MemphisFlash
- Posts: 2161
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
twice the distance from the centre to the end, 
So people either love the spreadsheet or Memphis pressed refresh page a few hundred times. Or both! Who cares, it still counts towards the new record!!!jimibt wrote: ↑Wed Oct 28, 2020 12:23 pmhow long is a piece of string...MemphisFlash wrote: ↑Wed Oct 28, 2020 12:19 pm575 views in 24 hours, that must be some kind of record!!!
Good wurk Memphis and everyone else, high fives all around
I reckon my tomato thread beat that.MemphisFlash wrote: ↑Wed Oct 28, 2020 12:19 pm575 views in 24 hours, that must be some kind of record!!!
It's easy to forget the 'click bate' factor. People click on any topic with an unusual or intriguing title.
talking of formulas and *bate*, maybe this is for next year: https://www.masterblend.com/4-18-38-tom ... %20systems.
masterblend away!!