Return to Answer

added 137 characters in body

Source Link

edited May 16, 2019 at 2:34

The built-in named range feature doesn't support non-adjacent ranges but there are some alternatives.

Use an auxiliary sheet to put together the values of non-adjacent ranges, so we have them together. We could use QUERY, FILTER, use {}notation, etc.
Use Google Apps Script to create custom function to be used as named ranges.
- NOTE: The "problem" with custom functions is that they only recalculate when their parameters change and that can't use volatile functions, like NOW() as arguments.
(UPDATE) Another alternative is to create an array of range references and use the Google Apps Script methods to handle range lists.

The built-in named range feature doesn't support non-adjacent ranges but there are some alternatives.

Use an auxiliary sheet to put together the values of non-adjacent ranges, so we have them together. We could use QUERY, FILTER, use {}notation, etc.
Use Google Apps Script to create custom function to be used as named ranges.
- NOTE: The "problem" with custom functions is that they only recalculate when their parameters change and that can't use volatile functions, like NOW() as arguments.

The built-in named range feature doesn't support non-adjacent ranges but there are some alternatives.

Use an auxiliary sheet to put together the values of non-adjacent ranges, so we have them together. We could use QUERY, FILTER, use {}notation, etc.
Use Google Apps Script to create custom function to be used as named ranges.
- NOTE: The "problem" with custom functions is that they only recalculate when their parameters change and that can't use volatile functions, like NOW() as arguments.
(UPDATE) Another alternative is to create an array of range references and use the Google Apps Script methods to handle range lists.

Source Link

created Jun 13, 2018 at 14:44

The built-in named range feature doesn't support non-adjacent ranges but there are some alternatives.

Use an auxiliary sheet to put together the values of non-adjacent ranges, so we have them together. We could use QUERY, FILTER, use {}notation, etc.
Use Google Apps Script to create custom function to be used as named ranges.
- NOTE: The "problem" with custom functions is that they only recalculate when their parameters change and that can't use volatile functions, like NOW() as arguments.