Distribute Across 7 Years- Formula Required|General Excel Questions & Answers|Excel Forum|My Online Training Hub

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 1^st 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