CODEWITHSUNDEEP
excelexcel-formulaexcel-2016vba
TheMightyNight
TheMightyNight

Reputation: 159

Excel Name Manager referring 2 ranges

In MS-Excel 2016's name manager if i'm trying to add data for 2 or more consecutive cells, it's working fine. e.g.

='Data Sets'!$C$2:$C$5

Now if i want to get only 2 data i.e. 

$C$2 & $C$5

I'm unable to do so. Kindly help.

enter image description here

Note: I'm using these for dynamic lists (INDIRECT).

Expected Output: {"LOF";"MSAIS"}

Upvotes: 0

Views: 382

Answers (1)

Vityata
Vityata

Reputation: 43585

Let's say you have test named range, refering to B4 and D4 like this:

enter image description here

To get B4 you need this formula:

=INDEX(test;1;1)

To get D4 you need this formula:

=INDEX(test;1;1;2)

This is how the name manager looks like for two different cells:

enter image description here

In the name range more than one range is shown like this {...}. This is done for internal reasons by Excel. However, if it was not, the expected output should have been like this: [{"LOF"};{"MSAIS"}] or something similar.

Upvotes: 2

Related Questions