Anti-nuisance lawsuit warning: The purpose of these notes is to remind me, Zoegond, of stuff or to help me work stuff out. They may contain mistakes.
Quick
($a, $b....) = unpack("A2A7...", $packed)
push( array, list )
Saturday, June 20, 2020
Google Query NO_COLUMN
Sometimes you can cure a persistent NO_COLUMN by putting the Range supplied to QUERY in curly brackets:
query({NamedRange}, "select sum(Col4) where Col1='Insane'")
I don't know why that works, as surely NamedRange is an array already, but it does.
