Sort and Match like Items in 2 Columns
 

The purpose of my project is to reconcile financial information. I have 2
colums of numbers...while most numbers in column A will match those in column
B, I do have some that do not match or are missing...must be out of balance :
) My objective is to sort the two columns in a manner with the data in both
columns match up. If there are mismatched numbers or missing numbers in one
column/row, then I want the alternating column/row to be left blank.

Sort and Match like Items in 2 Columns
 

Assume your data looks like this:
setA setB
18 11
16 20
10 10
19 12
12 19
22 21
29 30
26 16
17 29
13 13
27 14
14 25
21 28
23 22
15 17
28 26
25 24

Pivot Table Multiple Consolidation Ranges
Range Select the above data, including headers and
a blank column in front of data.
Layout Drag the Row button out of the ROW field and
drag in the Value button into the ROW field.
The DATA field should say Sum of Value
Options Uncheck grand totals.
Beside other stuff, the Pivot Table will show this result:
setA setB
10 10
11
12 12
13 13
14 14
15
16 16
17 17
18
19 19
20
21 21
22 22
23
24
25 25
26 26
27
28 28
29 29
30

Sort and Match like Items in 2 Columns
 

THank you! I will try it and let you know.

"Herbert Seidenberg" wrote:

Assume your data looks like this:
setA setB
18 11
16 20
10 10
19 12
12 19
22 21
29 30
26 16
17 29
13 13
27 14
14 25
21 28
23 22
15 17
28 26
25 24

Pivot Table Multiple Consolidation Ranges
Range Select the above data, including headers and
a blank column in front of data.
Layout Drag the Row button out of the ROW field and
drag in the Value button into the ROW field.
The DATA field should say Sum of Value
Options Uncheck grand totals.
Beside other stuff, the Pivot Table will show this result:
setA setB
10 10
11
12 12
13 13
14 14
15
16 16
17 17
18
19 19
20
21 21
22 22
23
24
25 25
26 26
27
28 28
29 29
30