# Recon balance and separating of data that balances to zero

1. ## Recon balance and separating of data that balances to zero

My most current task is going through the tax recons I'm in charge of and finding the entries that balance. And biggest road block is currently running into the possibilty that the descriptions/ explanations might not match 100%, there are lots of the same descriptions with no differentiating factors like (1,2,3 ...etc) or 1 dr/cr could have multiple offsetting entries to balance. Currently what I have to done is used the unique formula for the amount's column, and then used =if(countif(\$M6:M\$77,M6)=2,"x","") to find the matching unique. And the used the filter formula to pull all my matching to a separate part of worksheet. But this only gives the obvious matches.
I have not experience with queries, basic knowledge of pivot tables, and I have little experience with formulas, as my last position we did everything manually (not an ounce of excel formula usage or anything fancy).
This recon is one where I pull 10-100 accounts from E1 and put that table into a formula (array?) my boss put together that will separate all the accounts with activity and give me a variance based on the what are in the individual account tabs verses what I just inputted in the the formula. And then I have to go and collect the individual account entry detail to balance the tabs to that give me account varriance. And it's this last part I want to have something put together that can pull the matches to make sure they are balancing to "0" whether its 2=0 or 10= 0.
I have 20+ tabs I will need to repeat this on.
And if a VBA or Macro is my only solution, I need very detailed instructions on how to set these up. I've never set one up ever. I'm a novice.

2. ## Re: Pointers in the right direction please

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

There are currently 1 users browsing this thread. (0 members and 1 guests)