Wednesday, October 9, 2013

Excel 'fun'

Handy code for conditional formating here: http://superuser.com/questions/484215/setting-background-colour-of-cells-based-on-their-string-length

Find duplicates in data using conditional formating:  http://spreadsheets.about.com/od/excelformatting/qt/090516_find_duplicates_in_Excel.htm

Monday, August 5, 2013

Gmail - Deleting lots of old email at once

Find the old email using the following the search  (for example):

in: inbox before: 2013/01/05

Then select all and delete

Friday, February 1, 2013

Hopefully useful

Bash One-Liners :: bashoneliners.com

Vim..delete first 5 characters in a line
:%s/^.\{5}//gic