Most frequently occuring data in a row

=INDEX(B2:D2,MODE(MATCH(B2:D2,B2:D2,0)))

can be used for example to count votes

Splitting a colum into multiple columns Excel

=INDIRECT("Sheet1!R" & (ROW()-1)*3+1 & "C1", FALSE)


Say you have a long oclumn of data. You want to split it  into 3 columns such that, every third element  goes into each column.  for example youd data is: AAABBBCCCDDDEEEFFFGGGHHH
you want to split into 3 columns : ABCDEFGH, ABCDEFGH, ABCDEFGH. use the above formula

remove spaces in foldernames in linux

find -name "* *" -type d | rename 's/ /_/g' 

Opening a html table in excel

just use open with- and select Excel. As simple as that!

making global open-cv module available in a venv

This post is pefect.
http://stackoverflow.com/questions/13312139/opencv-and-python-virtualenv/19213369#19213369

the command 'sl'

do you know about the command sl in unix? I ran into it when I typed it  by mistake instead of  'ls'try it out and try not to get run over by the train :)

'cut' - in place file change: can't do

We cannot run a cut command on a file and change it in place For example:
cut -d',' -f -3 abc.txt>abc.txt

the above command leads to an empty abc.txt file