The FILTER function allows you to filter a range of data based on criteria you define. =FILTER(ARRAY,INCLUDE,[IF_EMPTY]) ARRAY = THE...

With just a little bit of cell formatting, a pinch of Excel function magic and Excel conditional formatting, you can create an...

Microsoft is releasing a handful of TEXT based functions that make splitting column values into multiple columns, super easy to do. For...

How can you take a column with duplicate values and extract just the unique values? Follow along as I demonstrate four techniques you can...