MicrosoftDear, you probably will not understand how much I appreciate the solution !!
Love you for that !
Worked out perfectly.....I would never have solved that myself. I have been trying since last 3 days in a quest to do it myself. But was unsuccessful.
Because I was quite limited in my approach and I have never used MMULT.
I need to open my eyes to the vast world of available formulas in EXCEL. Need to push the refresh button.
Thanks a Lot Sir ! That was marvellous.
I would request you to post any more solutions or versions for the same. Please do.
I am very keenly engaged to trying to extend the spill facility to all those functions in excel which do not have array capabilities inherent in them.
So trying various versions of the new Dynamic Array Formulas to use in conjuction with them to achieve that.
Thanks again
Regards
Kanwaljit
