May 19 2020 05:42 PM
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
Thank you in Advance and keep safe
John
May 20 2020 08:53 AM
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.