Category Archive: Excel

Excel: select subset of string based on delimiter

Explanation on how to pull apart strings in a certain cell using Excel built-in functions only.

Excel: Check if a row contains a newline

To find out if a cell contains the newline character in Excel, use this tip.

Excel: Finding the second (or Nth) largest number

To find out the second (or Nth) largest number in a column in Excel, just use the LARGE() function.