Re:Google Sheets Query Function (2016)
by airstrike on Wednesday November 07, 2018 @11:04AM
(#18399992)
Fuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuck! I am in awe. Thank God. I can barely contain my enthusiasm.
I literally wrote a "SUPERLOOKUP" formula in VBA that would apply SORT and UNIQUE but making the range dynamic would require an XLL which is a beast I never had time to tame as a hobbyist... this is a dream come true. My eyes are literally watery. Wow.
But you'll probably also love Mesh Spreadsheets: http://chrispsn.com/mesh-preview.html http://mesh-spreadsheet.com/