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.
Wishing a great week ahead!!
Microsoft Office Trainer / Consultant.