Excel Howto

From Korean Resource Center

Jump to: navigation, search
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
  1. Insert a row below the labels row
  2. =DATAROWS-COUNTBLANK(FULL COLUMN excluding the two top rows)
  3. copy & transpose paste in another spreadsheet
  4. delete the two rows
  5. 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

Personal tools
smallmenu
Toolbox2