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 various techniques to flip lists upside-down or left-to-right

Use various techniques to flip lists upside-down or left-to-right - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Use various techniques to flip lists upside-down or left-to-right

“

- [Instructor] When you work with lists, 2 sometimes you might want to flip a list upside down 3 or maybe even left to right in this worksheet called staff, 4 we've got some names over in columns A, B, and C. 5 Over in columns K, L and M, we've reversed the order. 6 So on the list on the right, 7 we see Evie Randall on top there, 8 but on the list over on the left hand side, 9 the names at the bottom, of course, 10 Susan Carr over in row two on the left side. 11 We see her name on the list on the right, 12 it's at the bottom and one by one, 13 you can see how the names are reversed. 14 Now we can do this in a couple of different ways. 15 One is to add an additional column to our first list 16 and sort on that basis. 17 Or we could be using one of two different functions, 18 a function called sort and one called sort by. 19 Both of those are newer dynamic array functions, 20 not everybody has them, eventually all Excel…

Contents