• Home
  • Courses
  • Articles
  • Downloads
  • About
Mail LinkedIn Facebook YouTube
Excel Evolution
 
Skip to content
  • Home
  • About Excel Evolution
  • Articles
  • Checkout
    • Purchase Confirmation
    • Purchase History
    • Transaction Failed
  • Courses
    • 1 One to One
    • 2 Basic
    • 3 Intermediate
    • 4 Advanced
    • 5 VBA
  • Downloads
  • Home
  • Learning
  • My Tickets
  • Submit Ticket
  • Table of Contents

Category: Financial

Lookups – understanding the binary search algorithm

binary search

A comprehensive explanation of how approximate lookups work, along with practical examples and use-cases.

Continue reading

1 August 2016 2 August 2016Blog, Financial, Formula aged analysis, approximate match, binary search, dynamic named range, exact match, half-interval search, hlookup, invoice aging, linear search, lookup, match, vlookup

ISIN Validation (M Function)

ISIN

An easy-to-implement function to validate an ISIN (International Securities Identification Number), using an M function in Power Query.

Continue reading

29 March 2016 29 March 2016Blog, Financial, Power Query function, international securities identification number, isin, luhn algorithm, m, power query

SEDOL Validation (VBA Function)

An easy-to-implement function to validate a SEDOL (Stock Exchange Daily Official List), from formula and/or VBA.

Continue reading

24 February 2016 2 August 2016Financial, Formula, VBA luhn algorithm, regex, SEDOL, Stock Exchange Daily Official List, udf, user defined function, vba

ISIN Validation (VBA Function)

ISIN

An easy-to-implement function to validate an ISIN (International Securities Identification Number), from formula and/or VBA.

Continue reading

14 January 2016 28 March 2016Financial, Formula, VBA international securities identification number, isin, luhn algorithm, regex, udf, user defined function, vba
  • Follow us on LinkedIn


© 2015 Excel Evolution Ltd, registered England and Wales, 06357765
Powered by Nirvana & WordPress.
Mail LinkedIn Facebook YouTube