Hello All,
I am using Excel 2013 and need a formula to calculate ageing of various equipment installed in different plants
I have made a sample for my problem which is attached herewith
I need a formula in C10, E10 and G10 which I can drag down to fill up the values
C10 - should count the Equipment from A2 till down and compare each equipment with the year in C2 till down and match the year with Period in B10 till down
E10 - should increment by the count of Eq in respective years
G10 - will sum the values for respective year comparing it with the Period
Sample data is small actual data will be much more
I have given some explanation next to each cell where the formula is required
Cells colored for explanation purpose only.
Hope to get some help
TIA
Sameer
Bookmarks