From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Use the FILTER and SORT functions to maintain updated lists and rapidly changing source data

Use the FILTER and SORT functions to maintain updated lists and rapidly changing source data - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Use the FILTER and SORT functions to maintain updated lists and rapidly changing source data

“

- [Instructor] On this worksheet, 2 we're seeing all the countries in the world 3 listed over in columns A, B, and C, 4 with their appropriate continents and their population. 5 And what we'd like to be able to do ultimately, 6 and we actually see it in place 7 on this particular worksheet, is have other columns, 8 columns E, F, and G for example, for Europe, 9 I, J, and K for Asia, and so on. 10 You see the other continents to the right. 11 We want to make sure that our lists are always up to date. 12 Let's say we need these numbers frequently. 13 The master list is in columns A, B, and C. 14 And ultimately we can set up the other lists 15 simply by using the filter and sort functions. 16 We possibly would need filter only but we can also use it 17 in combination with sort. 18 These two functions are what are called 19 dynamic array functions. 20 And we don't want to be confusing these with the commands 21 called…

Contents