Skip to main content

Posts

Get multiple lookup values in single cell

create Pivot table from multiple data ranges/tables

vlookup with vstack

Randbetween3

Randbetween2

Randbetween1

arraytotext

XLOOKUP multiple tables with vstack

Sequence

Geography

VSTACK office 365 function

Sortby office 365 function

Chooserows office 365 function

Choosecols office 365 function

Unique office 365 function

WRAPCOLS office 365 function

Wraprows office 365 function

Filter function office 365

TOCOL with IF function to do unpivot data