Tidbit:CSE functions in Excel

CSE functions (aka array formulas) in Excel are functions that apply across a range of cells to aggregate the result in once cell.

CSE functions are applied when a function is entered into the cell, and instead of leaving the cell pressing the enter key, it is left by pressing ctrl-shift-enter (hence the CSE name).

The functions are useful for generating lists of values in a single cell.

For example, a CSE function could be used to generate a semicolon separated list of email addresses based on a column of email addresses and a second column that is used as the filter.