From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Use the FILTER and UNIQUE functions together for dynamic extractions

Use the FILTER and UNIQUE functions together for dynamic extractions - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Use the FILTER and UNIQUE functions together for dynamic extractions

- [Instructor] We're looking at a worksheet here 2 that goes down to Row 910. 3 It's tracking sales data over a two-year period. 4 And what we'd like to be able to do 5 is to use the new filter function here. 6 You might not have this available just yet. 7 Currently, users of Microsoft 365 do have it available. 8 Eventually, all Excel users will have it. 9 We'd like to have a filtered list 10 using this new filter function 11 and also control its appearance 12 by using another function, 13 another new function called unique. 14 And we might also use another new function called sort. 15 These are all dynamic array functions 16 and they work a bit differently 17 than standard functions in Excel. 18 So I'll be using it here in cell K2. 19 And what I'd like to be able to do with this filter 20 is to first of all, 21 just show the data in Columns A, B, and C. 22 The data goes down to Row 910. 23 Now I could highlight the…

Contents