If you have a horizontal array and need to use it with a vertical range, Excel Video 352 can make your life much easier. If you’ve defined an array across columns but need to use it down rows, you’ll see in Excel Video 352 that you won’t get the right answer. Rather than redo your saved array to put it in rows or try to maintain a horizontal and a vertical saved array, try using the TRANSPOSE function. TRANSPOSE simply converts a horizontal range of cells to a vertical range, or vice versa. It’s an easy way to have one saved array work either horizontally or vertically.
We’ve spent a lot of time on some basic fundamentals of arrays. Stay tuned. We’ll start putting those fundamentals to work in the next Excel Video. Thanks for watching.