Tidbit:CSE functions in Excel: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m link fix |
||
| Line 1: | Line 1: | ||
CSE functions (aka [https://support.microsoft.com/en-us/office/ | CSE functions (aka [https://support.microsoft.com/en-us/office/guidelines-and-examples-of-array-formulas-7d94a64e-3ff3-4686-9372-ecfd5caa57c7 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). | 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). | ||
Revision as of 17:34, 2023 February 18
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.
This table contains the 4 bottom rows of data. Entering the formula <code>CONCAT(IF(B$2:B$5>"",A$1:A$5 & "; ","")) </code> into the top right cell and then clicking ctrl-shift-enter will populate the cell as seen here.
| A | B | |
| 1 | a@b.ca; d@b.ca; | |
| 2 | a@b.ca | x |
| 3 | b@b.ca | |
| 4 | c@b.ca | |
| 5 | d@b.ca | y |