# Pivot table so - Compare two columns for new and missing values

#### battlingwithexcel

##### Board Regular
Hi there,

I have a pivot table laid out similar to the below....the values in the columns represent aged debt and basically I need to identify which debt is 'new' i.e. appears in column 01/13 but not in 12/12 column (items in red), and which debt has been paid i.e. appeared in 12/12 column but is absent in 01/2013 column (items in green).

I need to be able to do this on a regular basis each week and compare the relevant list of debt with the previous week. Therefore ideally, I would like to be able to have a pivot table showing only the red and green items so I can easily double click on the totals to drill down to the list of invoices falling into each category...(each week I need to compile a list of paid and new debt). I can manually do this by clicking on the individual items but it is taking me SO long as there are tons of invoices to cross-check....

Can anyone help?

 Sum of Total 12/2012 01/2013 3 £31,163 £31,163 4 £52,399 5 £52,399 6 £64,708 £64,708 7 £64,708 £64,708 8 £627,517 £627,517 9 £627,517 £627,517 10 £19,766 11 £101,584 £101,584 12 £47,189 £47,189 13 £20,718 14 £33,677

<TBODY>
</TBODY>

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

#### MGORIYA

##### New Member
Try this ...

=IF(SUM(B3+C3)=B3,"Paid",IF(SUM(B3+C3)=C3,"new",""))
Then Filter column contain formula <> Blank....

Replies
0
Views
73
Replies
0
Views
587
Replies
0
Views
141
Replies
3
Views
137
Replies
0
Views
1K

1,195,963
Messages
6,012,589
Members
441,714
Latest member
mcgeesusana

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back