Use Of Excel Array Formula In Our Work!! - XLS Download

Hi,
First of all I wish everybody a very prosperous diwali.
This week we are considering a scenario to find out how excel array formula can help in our day to day work.
Have a look at the attachments which might give you an idea where you can use these types of formula in your work.
Thank you
Wishing a great week ahead!!
Regards,
Hariharan Ramakrishnan
Microsoft Office Trainer / Consultant.

dear sir i am working with increment in this year ,but i am not aware all excel formula for increment & experience , so i attached sample for exact i want. pl.do need full.

please help with shrinkage formula