Fast & Easy Reconciliation using Excel (any two data sets)

preview_player
Показать описание
This Reconciliation method can be applied to any two (or more) datasets that have a common unique ID. Super useful for position or cash reconciliations.

@A Day in Life of a Portfolio Analyst
Рекомендации по теме
Комментарии
Автор

What about hidden symbols and other formatting issues? You should use Power Pivot or Power Query and then use If statement to validate.

warrenanderson
Автор

I really like it. It worked for me in vendor statements reconciliation, But how I need to bring dates of 2 sets of data in pivot table

life-tzrg
Автор

do you have any videos of reconciling two sets of data with a different references

mustafeabdi
Автор

Please provide a sample file to practice. Thanks

SaiKiran-genr
Автор

why would you copy and paste to the other worksheet? Doesn't seem efficient

paulhan