Hi All,
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
Sam
Hi Sam
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.myonlinetraininghub.com/excel-rank-rank-avg-and-rank-eq-functions
Hope this helps
Sunny
