Forum

Notifications
Clear all

Distribute Across 7 Years- Formula Required

2 Posts
2 Users
0 Reactions
208 Views
(@trttrt)
Posts: 1
New Member
Topic starter
 

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

 
Posted : 24/07/2018 11:31 pm
(@sunnykow)
Posts: 1417
Noble Member
 

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

 
Posted : 25/07/2018 3:09 am
Share: