a/r

  1. D

    VBA with sumif syntax issues

    Hello I did my best to post using everything suggested but this is the best I can do. Here is a spreadsheet I am trying to work with. It is basically up to 200 rows and using columns A:H. I am also attaching my vba code. The code will add titles, formatting and some formulas. I am having...
    • dstepan
    • Thread
    • a/r activecell.formular1c1 false sumifaa xlnone
    • Replies: 11
    • Forum: Excel Questions
  2. D

    Lookup each value in a list based on another column with duplicates

    Hi all. I have a list of dates that contains some dates twice. I will provide some sample data below: 09/01/17 A/P 09/01/17 IM 09/05/17 A/R 11,867.00 09/07/17 IM 09/07/17...
  3. N

    intercompany accounts

    My spreadsheet has 20 rows and 20 columns containing accounts receivable information. I then have the same grid for accounts payable information. Below is a simplified version. I want to, as easy as possible, list the differences from what each company shows as a/r compared to what the...

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
Back
Top