TIL that you can’t change the CSV delimiter or enclosure characters on Excel for Mac or Apple Numbers. You have to use Open Office.
TIL how to build JSON strings in Excel with concatenate.
I never remember the keyboard shortcut for Fill Down in Excel on macOS, so I’m posting it here where I’ll have it. Control + D.
How to compare data columns of data from different sheets in Excel.
TIL how to deal with files in AppleScript and how to do conditional counts in Excel.
TIL how to concatenate columns and convert time in Excel and some more SQL functions.
TIL how to sum in Excel with filters and a trick for bringing myself back in perspective.