I have a Table that shows Account Numbers and Date of Payment
Most accounts have 2 Payments in the same month.
I need a formula that adds the total amount per Account number per month and puts it all into a new Table!
For example those 2 rows
<tbody>
1701
$200.00
Feb-2013
1701
$30.00...
I am having an issue with an IF/Then formula in Excel. If cell B has a value greater than 30 then I want the data from cell I2 to be placed in cell A. For example, when 2300487724 is imputed into B2 I want 01/09/2017 to appear in A2.
Hi,
Thanks to all the posts on here I have been able to copy, paste, butcher and fudge my way through to almost what I need.
I have a sheet with multiple columns with a list of sites which we may visit to carry out a Test, service, Repair or any combination of the three.
<tbody>
Site A...
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.