Home › Learn Excel › Lesson 10
One formula, many results: filter a list, remove duplicates and turn rows into columns.
UNIQUE removes the duplicates from a list. The answer spills into the cells below by itself. List every region once, starting in C2FILTER returns every row that meets a condition. The answer spills into the cells below by itself. List everyone who works in Sales, starting in D2TRANSPOSE flips a range: a column becomes a row. The answer spills into the cells next to it. Turn the column of quarters into a row, starting in C2