now i'm not a fan of arrays and always try to find an alternative here are 3 alternatives to 3 things normally seen done with array entered formulas
any more that can be added? or any improvements(apart from an array alternative of course) or is there anything plain wrong?
Bookmarks