Hello,
I'm wanting to create an indicator that shows me when a project has overspent for multiple months or under spent by multiple months. I want to do this for over 50 projects.
I have monthly spending by project. I'm considering using outlier formulas to show me when spending is abnormal...
Hello everyone I have a problem:
I have to calculate how much each car contributes as a percentage to give me a total spending balance in $, in a given rental period calculated as a percentage.
For example:
Car 1: spending balance 1000 $, on 75% of the time of which it was rented;
Car 2...
Hello,
I was wondering if it is possible to have a column in calculate based on the fields that are included. For example, if only market is available, I want the % of per capita spending to be divided by the total across all markets, but if I include market and product, have the % spending to...
I have monthly reports for projects that tell me how much has been spent on a project to the end of the month. I have 12 tables, one for each month with a list of projects and an amount. Each month as projects start and finish the list of projects will change and they may not be in the same...
Hello all,
This is my first post on this site but with the personal project I am doing it will probably not be the last.
Background on project:
Trying to create a personal finance tracker that will work across multiple devices (i.e home computer, wife and I's cellphones, etc.) and is very...
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.