All posts by jasu
Google Sheets Vlookup array
I was about to go nuts trying to figure out why I couldn’t enter an array for a VLOOKUP in Google Sheets. Quite a bit of Googling later it turns out that there’s BACKSLASH to separate arrays into columns – but only if you’re using a locale which uses a comma as number separator (instead of dot in the US/UK) and semi-colon for separating function values.
Thanks to https://www.benlcollins.com/spreadsheets/sheets-location/
Google Sheets – lookup a date and return the weekday (as text, not as an integer).
Dishonored 2 intro skip
Add to Steam Launch options
Drupal forms api problems
Spent the morning banging my head against my desk due to Drupal 7’s Forms API. I was trying to convert a regular POST-form to GET without any success, until I found this useful article http://eworldproblems.mbaynton.com/2015/03/handling-get-method-submissions-with-drupal-7s-forms-api/
Drupal 7 Forms API reference: https://api.drupal.org/api/drupal/developer%21topics%21forms_api_reference.html/7.x