No Picture
Apps Script & Java Script


Search() and Find() are pretty much the same. The only difference is that Find worries about matching case (upper/lower) and search doesn’t. That means that Brass is the same as brass as far as Search is concerned, but find thinks they are different. So you can […]

No Picture

Quirky Functions

Equation plots in Excel Execute SQL from Excel Respect a Filter with Sumproduct Search SumProduct SumProduct – prioritizing lookups Sumproduct Strangeness-2 Using match to categorize