Purpose and functionality of 'GapDub1'

The macro detects gaps and dublicates in series containing running numbers.

(1)

Series can consist of numbers only, or series can consist of numbers with prefix (e.g. 'AA001'). Series must end with a number.

(2)

Series are in a column of an Excel worksheet. Series start on the first row of a table, with a column heading. Series in any column of a table can be analyzed.

(3)

There can be several series in one column. Series and their elements need not to be in order; thus there is no need to pre-index a table under analysis.

Macro cannot be run succesfully in series, where there is at least one element that does not end with a number. User will be informed in these cases [1].

Information about the run of the macro and results of the run will be reported in a new table in the workbook, where the table analyzed exists. The results worksheet contains three section: 'Run', 'Gaps', and 'Duplicates'.

(1)

'Run': Date and time of the run; selected workbook, worksheet, column; and count of rows analyzed.

(2)

'Gaps': list of missing numbers, their count; total count of missing numbers; and total count of gaps.

(3)

'Duplicates': list of duplicates; total count of duplicate cases. E.g. if there are three times 'AA099', this is one duplicate case.

[1] Message e.g.: 'Macro cannot continue. Number of cells without numbers: 1'.