https://www.vertex42.com/ExcelTips/unicode-symbols.html # Functions - `IFS`: a switch statement like `case_when`! - `CHOOSE`: a terser situational alternative to an `INDEX(MATCH())` e.g. for looking up configured values # Techniques - Dynamically-sized ranges for Naming: `OFFSET(first_cell, 0, 0, COUNTA(column), 1) > the problem goes beyond the specific use of FILTER and arises from the fact that you are offering an array of values to an antiquated bit of functionality that only accepts Range references. - Dynamically select columns: - https://www.excelcampus.com/functions/filter-non-adjacent-columns/ - Pattern is: `INDEX(range, SEQUENCE(ROWS(range)), XMATCH(cols_to_find, range_for_headers, 0))` - You can also pick columns by position: - `INDEX(range, SEQUENCE(ROWS(range)), {1, ..., n})`