No as mentioned in both threads, I am aware of the CSE option, but this is somewhat elegant as it requires you to ctrl+shift+enter, the range. Particularly frustrating if you are not sure how many columns will be populated and pulling perhaps the top 50 ranked items. The formula I have described above populates a grid the the formula in the top left cell. The goal is a tool that can be used by less knowledgeable users. Therefore any function involving a instruction manual is not ideal.
It's quite frustrating as I have an example of a function that does this, but cannot see the code, and nobody seems to have heard of a method to do this.
Bookmarks