Excel Unplugged

Category Archives: Dynamic Ranges

Excel FILTER Function – The Function that does Everything

Last year, Microsoft announced the introduction of a new group of functions in Excel, known as dynamic array functions. One of these – the FILTER function – is ...

Get a random subset of data with Power Query

The other day I made a Dashboard with a classic by time and relevant dimensions analysis. The data was pulled from Azure SQL DB, so Power Query was the method I ...

Dynamic Power Query

The following post was written as the reply to a great question Dane asked in the Comments section of the Power Query’s Unpivot Function post I wrote back in ...

Dynamic ranges in Excel

For the purposes of this article (if you wish to follow long and I strongly suggest you do so) we will be using a workbook that has the A2:E10 Range filled with the ...

503 Service Unavailable

Service Unavailable

The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.

Additionally, a 503 Service Unavailable error was encountered while trying to use an ErrorDocument to handle the request.