© Matti Mattila, CPFA, CISA, CIA

Gap and Duplicate detection macros

Previous item Next item Previous menu

Purpose of the Macros

The macros introduced here help in detecting gaps and duplicates in any series ending with a running number. To series valid for analyses belong among others the ones based on date format 'YYYY/MM/DD'.

'GapDup1' is one of the macros of ExcAud.

Gap & Duplicate Detection Macros

Gap and Duplicate Detection Macro #1 (GapDub1)
24.04.2011 - 21.06.2011