- 1
- 5 254
Olga R
United States
เข้าร่วมเมื่อ 21 พ.ย. 2010
Fast & Easy Reconciliation using Excel (any two data sets)
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
@A Day in Life of a Portfolio Analyst
มุมมอง: 5 257
What about hidden symbols and other formatting issues? You should use Power Pivot or Power Query and then use If statement to validate.
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
why would you copy and paste to the other worksheet? Doesn't seem efficient
do you have any videos of reconciling two sets of data with a different references
Дякую
❤❤❤❤❤
Please provide a sample file to practice. Thanks
Excellent 👍🏿👍🏾👍🏼👍🏻👍🏼👍🏾👍🏼👍🏻👍🏼👍🏾