by Nate Moore | May 6, 2013 | Arrays
Excel Video 354 has a practical example of an array formula. We’ll write a formula that loops through a range of cells to sum the collections if the year equals 2009. The array formula is made up of two parts that might be best understood from the inside out. The...
by Nate Moore | May 1, 2013 | Arrays
Excel Video 353 has our first trick with arrays. I’ll show you a quick way to get the name of range of cells you’ve named using Name Manager, and then we’re off to work. Sometimes this helps and sometimes this doesn’t help, but one of the features of an array is that...
by Nate Moore | Apr 29, 2013 | Arrays
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...
by Nate Moore | Apr 24, 2013 | Arrays
If you need to make the named array constants we created in Excel Video 350 a little more flexible, watch Excel Video 351. Today we’ll define our array of constants as a range instead of entering the numbers 1 through 5 in the array. Now if we decide to change our...
by Nate Moore | Apr 22, 2013 | Arrays
Today we’ll simplify the formula we created in Excel Video 349 by naming an array in Excel Video 350. If you’re going to reuse an array with constants, an easy way to do it is to name the array. Watch how I have to put braces around the array in the formula and how I...
