How to INDEX multiple columns

I needed to check multiple columns in different spreadsheets and output the matching result. I wasn’t sure that VLOOKUP would work for this case and INDEX-MATCH is supposed to be better anyway, so I used the following code. It uses IFERROR to nest MATCH functions: The above checks for matches in colums A, Q, and P in SpreadsheetA, and columns…

Continue Reading

How to SORT multiple columns in Google Sheets

Yesterday I was working on a spreadsheet that needed to SORT items from several different columns. SORT only accepts one argument, and I couldn’t find any examples online about how (or if) you could SORT multiple columns. Maybe this is obvious to everyone else, but it wasn’t to me. The answer is to put arguments within an array like this…

Continue Reading

I am a Machine

I worked on MormonShare.com over the weekend and was able to get a new Feeds importer working properly and I indexed about 200 new items to the website by hand, and probably automatically imported another 300.  Now they are tagged so they’ll show up in the activities, printables section, and even the sharing time lesson index on Mormon Share.  Those…

Continue Reading

Why I’m switching from Drupal to WordPress

Despite years of fighting with Drupal to try to speed it up, I’ve just never been able to get things going fast enough.  We tried everything — even paid for a second file server for downloads — to try to handle the load.  Never could do it.  A few months back I decided to switch to WordPress.  Here’s the result:…

Continue Reading