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
GetFormula
ใณใกใณใ