need formula based on years

[yallamanda.b]

HI Team,

Good afternoon
could you please share the formula based on dropdown values will popup.

PFA for more information

Thanks

 

[chirayu]

attached

 

[Syedali]

attached

WOW SUPER BRO.. AM STRUGGLING..... I can't express my words... Really i learnt superb and great knowledge from this answer.

 

[Nikunj Rastogi]

plz find answer

 

[Nikunj Rastogi]

we do not need to use different formulas. Use subtotal instead of any other formula.

 

[John Jairo V]

Hi, to all!

AGGREGATE function really contain all of the operations needed in this exercise. Try to avoid (if possible) volatile functions like OFFSET. In this case, using INDEX instead is better.

Please check file. Blessings!

 

[Syedali]

Hi, to all!

AGGREGATE function really contain all of the operations needed in this exercise. Try to avoid (if possible) volatile functions like OFFSET. In this case, using INDEX instead is better.

Please check file. Blessings!

Hi,
For you this question may be foolish.... But i don't know how "AGGREGATE FUNCTION" functioning can you explain if you have time.

 

[NARAYANK991]

Hi ,

See if these links help :

https://www.sumproduct.com/thought/aggregate

http://www.exceluser.com/excel_help/functions/function-aggregate.htm

Narayan

 

[Nikunj Rastogi]

Thanks for inform us a new formula aggregate.