Named Range

[bluenose5709]

Hi,

I have a named range in my workbook and when referencing it I can select the individual columns within the range. When I reference the range =RangeName and include the first square bracket =RangeName[ It then shows me the various columns that I may select from that range this is great and works a treat

My question is:

I am trying to recreate the novel but failing miserably. I select all. My data. Eg “A1:D100” and then. Define a name, eg: “NewRange”. It appears in my name manager and if I simple put =NewRange then the whole data set will appear. What I can’t do is choose an individual columns within from within as the square bracket does not detect anything.

Could anyone share where I may be going wrong…?


For context, I have a sheet that references a range and filters on team name. This works fine. I now wish to add points from my new range that will be in column D but need to Filter on the team name in Column C. The results will be down on a different sheet.

Thank you

 

[JamesCanale]

Use "Format as Table" - and make sure you have header rows.

Then give it a name in Table Design

 

[bluenose5709]

James,

Thank you. I shall give that a go and come back to you with my result's

 

[bluenose5709]

Use "Format as Table" - and make sure you have header rows.
View attachment 120894
Then give it a name in Table Design
View attachment 120895

James,

Apologies for the slow reply. I have now just given that a go and as you can see from the image below, this has worked, however this have new generated a problem that i did not have before

As you can see above, i now have a #SPILL error in the first two columns. this is something that is not there when the cells are not formatted as a table...? If i Undo formatting as a table then all data comes back no problem but when formatting as a table i loose all data and receive the #SPILL Error. Any Ideas...?

Thank you

 

[bluenose5709]

James,

Apologies for the slow reply. I have now just given that a go and as you can see from the image below, this has worked, however this have new generated a problem that i did not have before

View attachment 120967

As you can see above, i now have a #SPILL error in the first two columns. this is something that is not there when the cells are not formatted as a table...? If i Undo formatting as a table then all data comes back no problem but when formatting as a table i loose all data and receive the #SPILL Error. Any Ideas...?

Thank you

James,

I think that I have concluded that i cant have an array formatted as a table,

Thank you for your help..

 

[JamesCanale]

You are right - you cannot spill in a table. If the basis of the table is some filter of another table, you are out of luck using format-as-table. I use tables as the source data.