Reconcile huge data set with multiple criteria filters

blublublub

New Member
Joined
Mar 12, 2015
Messages
1
Hi, i'm having trouble reconciling the following data sets. Basically I have 2 sheets and needs reconciling. I have done a pivot table to make reconciliation easier but run into trouble when i add more criterias.

Filter criteria as follows:
1st sheet: Filter Y (N/Y), I (I/E) - 2nd sheet: Filter Y (N/Y)

Sum Values through all time period (D1-D7) of each individual asset and portfolio
e.g. Asset (AAA), PF (1) = Value (57) should match with the same sum on sheet 2.

The number of portfolios and asset classes are alot.
I dont need an exact answer... just need ideas on how to approach or simplify this.... thanks in advance




1st sheet

Portfolio2Asset2Time2Value2N/YI/E
1AAAD123YI
1AAAD332YI
1AAAD72YI
2AAAD252YI
3AAAD35NI
3AAAD72YI
4AAAD71230YI
5AAAD123NI
5AAAD22YI
11AAAD12YI
12AAAD131YI
1CCCD14YI
2CCCD224YI
3CCCD146YI
3CCCD79YI
1DDDD112YI
2DDDD72YE
4DDDD134NI
5DDDD74YI

<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>

2nd sheet

PortfolioAssetTimeValueY/N
1AAAD123Y
1AAAD332Y
1AAAD72Y
2AAAD252Y
3AAAD35N
3AAAD72Y
4AAAD7123Y
5AAAD123N
5AAAD22Y
1CCCD14Y
2CCCD224Y
3CCCD146Y
3CCCD79Y
1DDDD112Y
2DDDD72Y
4DDDD134N
5DDDD74Y

<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,558
Latest member
aivin

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?

Disable AdBlock

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
Back
Top