Forum Discussion
Array function is not working anymore
Dear all I am using an array function that work so far, now it is not anymore, to be more precise, it is working in excel sheets that I made last year, using the same formula in the same excel sheet...
StefanMeier See if the attached file works for you. In E4:F7 I used your formula, but since you tagged your post with Office365, you may want to use the Filter function as demonstrated in cell I4.
- Thanks a lot, your solution is working perfect for me!
Even my formula is working in your sheet, but why?StefanMeier Can't really answer why. Sorry?
- Riny_van_Eekelen thanks a lot anyway , big help, it is really weird... Your sheet is now working with my formula as long I do not change the amount of cells.
