I've just cottoned on to the power of Dynamic array, yep a little slow :), anyway the first question that came to mind when I saw the power of what you have done is wouldn't it be nice if the results where also a "hyperlink" back to the source cell and row, so one could investigate further all the other attributes that my be worth enquiring on?.
To me this would make this even more/really useful for those spreadsheets that are beyond one screen in size?
I will experiment more, as I'm in my naïve stage of learning this functionality, but I can already see some major advantages of utilising this in some of my larger spreadsheets
Hello! You've posted your question in the Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future.