Contents1 Introduction2 Structure3 Character Codes3.1 Text Characters3.2 Number Characters3.3 Date Characters3.4 Time Characters4 Conditional Number Formats5 Using Colours6 Examples6.1 Display a signature strip6.2 Prefix a number with a single character6.3 Suffix a number with a text string6.4 Pad a number with n leading zero’s6.5 Align Positive and Negative numbers6.6 Understanding…
Contents1 Tables:2 Formulas:3 Pivot Tables:4 Conclusion: Who does the caveman go to when he has a tooth ache? The dentist of course! Only back then, as you can imagine, the dentists’ tools were quite different to those used today. It has taken millennia to refine the tools we use in…
A comprehensive explanation of how approximate lookups work, along with practical examples and use-cases.
RandBetweenA is an Excel worksheet function (UDF) that generate unique random numbers between a minimum and maximum number range.
A handful of VBA routines to help you create, modify, delete and execute queries stored on your database (using Access for sake of example).
An easy-to-implement function to validate an ISIN (International Securities Identification Number), using an M function in Power Query.
An easy-to-implement function to validate a SEDOL (Stock Exchange Daily Official List), from formula and/or VBA.
An easy-to-implement function to validate an ISIN (International Securities Identification Number), from formula and/or VBA.