Hi,
I have supplier account transactions and with each invoice and payment I know what is outstanding balance but I want to check/get a formula where I can see at end of each month what as owed.
The issue is for example in July last transaction was 15th July, in August the last transaction...
I have Excel 2016 on my computer and am trying to use Power Query for the first time. I am trying to do something that I thought would be easy but I'm having the hardest time figuring out how to make Power Query work. Here is what I am trying to do any tips are appreciated:
I have two excel...
I have a work book that has over 200 tabs. The summary tab has all 200+ members listed with their balances. The balances are found on the same cell of the other 200+ tabs.
Each tab is titled as each member which is the same as column A on the suammary tab.
is there a function I can use so...
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.