Excel is a spreadsheet program developed by Microsoft.
Excel usage tips
How to unpivot data
- How to convert data from a row x col 2-dimensional pivot format back to a "flat" format
- In Google Sheets
Frequency
=COUNTIF(Raw!B$2:Raw!B$94922,A2)
How to extract columns with information if a DB export has hundreds of columns that are empty
- Insert a row below the labels row
- =DATAROWS-COUNTBLANK(FULL COLUMN excluding the two top rows)
- copy & transpose paste in another spreadsheet
- delete the two rows
- select empty columns and delete them
=> didn't work in a spreadsheet with 35,000 entries
To use the numeric content of a cell to define the location of another cell within a formula
http://www.contextures.com/xlFunctions01.html#Offset
Last word in Cell
=RIGHT(A2,LEN(A2)-FIND("*",SUBSTITUTE(A2," ","*",LEN(A2)-LEN(SUBSTITUTE(A2," ","")))))
from http://www.exceltip.com/st/Extract_the_last_word_in_a_cell_in_Microsoft_Excel/368.html