Excel
Array formulas in Excel: from one cell to a complete list
One formula can calculate six values, select matching rows or create a list of categories. I explain how to predict its output and catch mistakes before they reach a report.
Tag
array formulas
KajoData articles about array formulas. Practical knowledge about data analysis, tools and careers.
Articles: 1