Save it 🎉💚🎉 Splitting a Lists with Excel: 19-Second FILTER Function Tutorial

Description: "Harness the potential of Excel's FILTER function! In this brief 19-second guide, we'll show you how to effortlessly filter a list into multiple columns - a must-have skill for product managers wanting to enhance their data sorting abilities. Subscribe today for more crucial Excel tips!

Subscribe to the Newsletter 👍: gfnewsletter.beehiiv.com/
Check out the website 😎: getformula.tech/

In the example, I am using a list of team members that are mixed up in a single list. Using the filter function, that list of users is then filtered into three different lists based on the team the user is associated with.

Note: The filter function data is dynamic, so you can change the team association in the source columns for a given user, and it will update the filtered list automatically!!!

1) Use the filter function =filter(
2) Select the values to filter =filter($B$6:$B$17,
3) Select the sorting criteria =filter($B$6:$B$17,$C$6:$C$17
4) Set the column filter equal to a value =filter($B$6:$B$17,$C$6:$C$17=E5
5) Close function =filter($B$6:$B$17,$C$6:$C$17=E5) and hit return

As the filter values and sorting criteria are locked ($), you can drag the function to the other cells in the table, and will automatically populate.

Tips:
• To select a column of cells: Ctrl + Shift + Down Arrow
• To lock a range of cells: F4

#Excel #ExcelTutorial #FILTERFunction #DataManagement #ProductManagement #ExcelFunctions