creating an array from non-adjacent cells - MrExcel
Dec 9, 2010 · However, my data are not in adjacent cells, which is the way I'm used to using array data (e.g. A2:A10 would be array 1). Is there a way to select several non-adjacent cells as an array? For …
Convert a set of non-contiguous values into an array for use in ...
Jan 31, 2017 · Goal is to get a set of non-contiguous values from a row into an array so it can be combined (e.g. SUMPRODUCT) with other arrays. The values in the array...
Select non-contiguous cells using Range in VBA - MrExcel
Jun 30, 2004 · How do I use a variable to replicate non-contiguous selection the first part of the code? I've tried & and Cells and separate Range statements but I'm stumped - it must be so easy yet it's …
Array formula - non contiguous range | MrExcel Message Board
Mar 10, 2005 · Hi all, I am working with an array formula that sums the values across non-contiguous ranges. Note that there are 2 columns in the last value range...
Any way to get a SUMPRODUCT formula for non-contiguous cells?
Mar 31, 2011 · No, I don't think you can use SUMPRODUCT on non-contiguous ranges). But you could use a number of other formulas for your simple example, like: =SUMPRODUCT …
Filling a Non-Contiguous Range with an Array with VBA
Mar 11, 2014 · Hi lyanik Welcome to the board It's true that you can do a direct assignment of an array to a range when the range is continuous. For a non-continuous range, a multi-area range, that is, …
quartile calculation relative to a multiple, non-contiguous ... - MrExcel
Nov 20, 2017 · Goodmorning , I have to calculate the first quartile (25 percentile) and the third quartile (75 percentile) of a multiple, non-contiguous cell range. While calculating the minimum and maximum …
VBA - Copying Non-Contiguous Ranges in/out of (an) Array (s)
Dec 15, 2024 · I have lots of worksheets which routinely get copied into a master sheet. The VBA for one example is below. Everything works but it does get a bit slow as each sheet gets copied from. …
VBA - Copying Non-Contiguous Ranges in/out of (an) Array (s)
Jan 15, 2025 · I'm wondering if using an array - or arrays - would speed it up? The main problem is the copy from / paste to data is in non-contiguous ranges. Click to expand... Although you have quite a …
Non-contiguous array of cells | MrExcel Message Board
Jul 31, 2008 · I'm relatively new to Excel formulas and I'm trying to figure out how to pass in a non-contiguous set of cells to formulas (index and match) that expect arrays as an argument. Let me try …