How to validate an MPAN in Excel

A Meter Point Administration Number is a unique number that identfies your electricity meter(s). Every electricity customer in Great Britain has one. (Some customers have more than one.) You can find out more on Wikipedia.

I work with a lot of data that includes MPANs, and I often come across invalid ones. So I wrote a single-cell MPAN-validating formula that I can put into my spreadsheets, and whilst I was at it, made a spreadsheet that explains how the validation algorithm works.

tl;dr: Get the spreadsheet

[Read More]