The Excel UNIQUE function extracts unique values from a range or array. The result is a dynamic array that automatically updates when source data changes. UNIQUE is not case-sensitive and works with t
The Excel LAMBDA function provides a way to create custom functions that can be reused throughout a workbook, without VBA or macros.
The Excel LET function lets you define named variables in a formula. There are two primary reasons you might want to do this: (1) to improve performance by eliminating redundant calculations and (2) t
The Excel REDUCE function applies a custom LAMBDA function to each element in a given array and accumulates results to a single value.
The Excel IFS function can run multiple tests and return a value corresponding to the first TRUE result. Use the IFS function to evaluate multiple conditions without multiple nested IF statements. IFS
The SCAN function applies a custom calculation to each element in a given array or range and returns an array that contains the intermediate values created during the scan. SCAN can be used to generat
Even amid pushback on ESG, expectations for companies to help solve global challenges are rising — not retreating. A new *TSX 60 Social Purpose Report Card...
The Excel SWITCH function compares one value against a list of values, and returns a result corresponding to the first match found. When no match is found, SWITCH can return an optional default value.
