How to create a position reconciliation in Microsoft Excel

Email me for questions, comments or request sample files: ninja.hf.ops@gmail.com

Steps to building a position reconciliation:

1. Open each file
2. Open a new blank workbook
2. Dump data from each file into a tab
3. Create a third reconciliation tab
4. Label headers
5. Copy/paste unique identifiers
6. Remove duplicate values
7. Enter sumif and difference formulas
8. Pull formulas down

excel,vba,microsoft excel,operations,ops,hedge fund,fund admin,finance,reconciliation,rec,position reconciliation,position rec,