From the course: Excel Tips Weekly

Unlock this course with a free trial

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

Flip the left-to-right order of columns with the INDEX function or sort by columns

Flip the left-to-right order of columns with the INDEX function or sort by columns - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Flip the left-to-right order of columns with the INDEX function or sort by columns

“

- [Instructor] Sometimes you encounter a list 2 where the data is not quite in the order 3 that you want it to be in. 4 Here's a list here of various items 5 that we have available in our inventory. 6 And off to the right, you can see 7 that sales are being tracked for the year 2016, 8 '15, et cetera, going this way. 9 But you're thinking, and I'll zoom back first, 10 that you'd like to see these entries in reverse order. 11 So off to the right, in other words, you'd like 12 to see the year 2007 all the way over to 2016. 13 Now we can do this in a couple of ways 14 and I think you'll realize which one is going to be better, 15 but let's show you both of them. 16 One is by way of what we call the index function. 17 The index function allows us to pull data out 18 of a list based on a column and row reference. 19 So let's imagine as we're looking at the data here, 20 and we can actually do this for the years as well…

Contents