Forum Discussion

Tyus_510's avatar
Tyus_510
Copper Contributor
Nov 18, 2019

ActiveData add-in

Hello all. I have a project that requires me to sort through expenses and find which ones don't have a matching debit or credit. One solution I saw on Youtube was using the ActiveData add-in. The only problem is I cannot figure out how to add it to my excel. Any suggestions?

BI & Data Analysis
excel
office 365

1 Reply

  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Nov 18, 2019
    Can you post a small sample file of the type of data you are matching. Is it purely based on the value or are there other identifiers.

    Are you familiar with Excel's Power Query? That can be great at helping with reconciliation work

Resources