Building an Excel football league table — 5 years on

Let’s take dynamic arrays to the extreme.

Five years ago (almost to the day), I published my first-ever Medium story. It also happened to be on my birthday, funnily enough.

What did I decide to write about?

Well, what better place to start than the very thing that got me into Excel in the first place?

That’s right — football league tables.

There were already numerous sources that had covered how to do this, so I thought: what can I do differently?

I didn’t just want to show you the old-fashioned way of building them, as dynamic arrays had just burst onto the scene. At the same time, I didn’t want to neglect compatibility, as many people were still stuck with dusty old versions of Excel.

Therefore, I was compelled to showcase the old school methods and the new ones. In fact, just look at what I said at the end of that article:

“Hopefully the workbook examples have given you food for thought with how you can go about creating formulas that make use of Excel’s dynamic array powers. The…