The New Table

New Table

-

Picture 1 is about the new table. The table is in a new workbook, on worksheet 'JoiTab'. The workbook is not automatically saved on computer after the run.

-

The new table has all the rows of table 'T1', and those rows of 'T2' where its column values of 'T2A' [in table 'T2'] and 'T1A' [in table 'T1'] match.

-

The new table is indexed in ascending order in terms of values of 'T1A'.

-

In columns 'PriRow' and 'SecRow' there are the order numbers that each row had in the [unindexed] source tables 'T1' and 'T2' respectively.

-

Using 'PriRow' and 'SecRow' information, with Excel's 'Data - Sort', it is simple to arrange the rows of the new table according to the row order of tables 'T1' or 'T2' [1].

-

In column 'MatCod' there is one row without secondary match (match code '1'), while other eight rows have secondary match (match code value '3').

-

In column 'H' there is main history information about the run: names of the source tables, ranges selected in them; name of the new worksheet; and date and time of the run.

[1] Please, note that Excel is able to limit this operation only to selected columns (here 'A:G').