Join Dennis Taylor for an in-depth discussion in this video Flip the left-to-right order of columns with the INDEX function or sort by columns, part of Excel Tips Weekly.
- [Instructor] Sometimes you encounter a list…where the data is not quite in the order…that you want it to be in.…Here's a list here of various items…that we have available in our inventory,…and off to the right you can see that…sales are being tracked the year 2016, 15, et cetera…going this way, but you're thinking,…and I'll zoom back first, that you'd like…to see these entries in reverse order.…So, off to the right.…In other words, you'd like to see the year 2007…all the way over to 2016.…Now, we can do this in a couple ways,…and I think you'll realize which one is going to be better,…but let's show you both of them.…
One is by of what we call the index function.…The index function allows us to pull data…out of a list based on a column and row reference.…So, let's imagine as we're looking at the data here,…and we can actually do this for the years, as well, too.…Right here what we want to do is to…pull out data from this column,…and right here we want to pull out…data from the next column over, and so on,…and we can take advantage of the idea…
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Skill Level Appropriate for all
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.