July 24, 2018
Need some guidance. Need to submit a 7 year asset replacement plan. We have around 50000 Assets each with Age and other information which determines replacement year. But after the submission Management may increase/decease budget for particular year (S). We may have to re do the working to show which asset is getting replaced which year based on allotted budget every year.
I need a formula which will Number 50000 assets from 1 to 50000 based on their Age. But only problem is sometime there will be manual feed where Some assets needs to be replaced in the 1st Year.
With this formula I should be able to just enter 7 Year Budget amount and formula should determine which assets gets replaced when.
Hope I made some sense of my situation. Any help ? Thanks
June 25, 2016
If you have the assets age in a column then you could try using the RANK function to do what you wanted.
You can learn more about it here https://www.myonlinetraininghu.....-functions
Hope this helps