From the course: Excel: Lookup Functions in Depth

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Use the SORT and SORTBY functions to create new lists

Use the SORT and SORTBY functions to create new lists

From the course: Excel: Lookup Functions in Depth

Start my 1-month free trial

Use the SORT and SORTBY functions to create new lists

“

- [ Instructor] For many Excel users, the most common data management tool is sort, but we also have two new functions, one called sort another called sort by, and these are both dynamic array functions we can write a single formula in cell and get multiple results spilling across many cells. You will not have access to this function unless you have Microsoft 365. Ultimately it will be available to all Excel users. I want to keep this list on the screen, 999 rows of data here, but I also want a sorted version of it, and not necessarily showing all the data, but just the data of greatest interest to me right now. And I might have multiple copies off to the right. So in cell I2, I'm going to be using the sort function. In its simplest form, all I want to do is to sort that data it's 999 rows so I'll highlight the data from A2 over to D9. I only want to to see the data out of those four columns and rather than highlighting…

Contents