Formulas

Fuzzy match noisy data

To match and summarize noisy data in Excel, where the same value appears in many different forms, you can use a map table together with the XLOOKUP function and the GROUPBY function. In the example sh

Random list of names

To create a random list of names, you can use a formula based on the TAKE function, SORTBY function, and the RANDARRAY function. In the example shown, the formula in D5 is: =TAKE(SORTBY(B5:B104,RANDAR

Count unique values with criteria

To count unique values with one or more conditions, you can use a formula based on UNIQUE, LEN, and FILTER. In the example shown, the formula in H7 is: =SUM(--(LEN(UNIQUE(FILTER(B6:B15,C6:C15=H6,"")))

Reverse a list or range

To reverse a list (i.e. arrange the values in a range in reverse order), you can use a formula based on the SORTBY function and the SEQUENCE function. In the example shown, the formula in D5, copied d

GROUPBY with monthly totals

To generate monthly totals using the GROUPBY function, you can use a formula that integrates several functions in Excel, including GROUPBY, CHOOSECOLS, HSTACK, TEXT, MONTH, and SUM. In the worksheet s

Coração de Ferro desafia fórmulas clássicas e mostra que futuro do MCU já começou | Review

Lei de Fourier: o que é e fórmulas (aprenda a calcular)

8 dicas no Excel para otimizar e acelerar as fórmulas