reconcile

  1. A Durfani

    Reconcile Two Columns BUT also Consider duplicate values

    I have two columns A and B I want to find Number in column A but NOT in column B, Number in column B but not in column A. AB1AB211322432543654 I am using this formula by CA_Punit C2...
  2. K

    Reconciling Brokerage/Managed Fund Investment statements to books with journal entry in Excel

    Hello. I am using an investment tracking Excel spreadshee. that is supposed to result in a perfectly balanced journal entry, once all the information from the statement is entered. I am always having a difference. I am also having to add GLs for things like Accrued Interest on Bonds, where the...
  3. J

    Find a specific amount outstanding?

    Hi all, I am looking to find a specific amount difference (36446.88) based on multiple amounts matching. I have 71 different scenarios of amounts that could add up to the specific amount mentioned above. Is there a way to get Excel to look at every possibility of matching specific figures to...
  4. H

    Macros to reconcile Fulfilled by Amazon

    Hi, Does anyone have a macro or a template builder to reconcile Fulfilled by Amazon (FBA) inventory Thanks in advance Hiten
  5. B

    Reconcile huge data set with multiple criteria filters

    Hi, i'm having trouble reconciling the following data sets. Basically I have 2 sheets and needs reconciling. I have done a pivot table to make reconciliation easier but run into trouble when i add more criterias. Filter criteria as follows: 1st sheet: Filter Y (N/Y), I (I/E) -...
  6. E

    reconciling countif?????

    I'm head deep in reconciling countif formula... I have a spreadsheet containing 465 rows of data. Each question is tied to a subtopic. I've used a countif formula to count how many times I'm using all of the topics. I come up with 491 uses of all subtopics. How can this be if I only have 465...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top