I propose to create Custom User-Defined Excel Functions using VBA Despite all the functions provided by Excel, you may need one that you just don’t see offered. Excel lets you create your own functions by using VBA programming code - User-Defined Excel Functions. Benefits of User-Defined Excel Functions: - create complex or custom math functions, - simplify formulas that would otherwise be extremely long "mega formulas", - different kinds of diagnostics (such as checking cell formats etc), - any text manipulation, and so much more...