Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Level 1

0 points

Can I use Names for a group of cells in Numbers

I have a list that when selected uses the content to define another list.

The first list is in cell B3 and the next list is defined by the following functions in cell B5 = INDIRECT(SUBSTITUTE(B3," ", "")

The text in B3 (Fruit) is the same as the names (group Fruit) in cell H2:H5 i.e H2 = Apples, H3 = Oranges, H4 = Plums & H5 = Grapes; then list in cell B5 will be list Fruit.

Hope this explained is clear.

Thanks in anticipation.

GeorgemcS

iPad, iOS 8.3

Posted on May 11, 2015 2:14 PM

17 replies

GeorgemcS Author

Level 1

0 points

May 23, 2015 10:57 AM in response to jaxjason

Just got back online and tried the Range function as defined by Wayne above worked well for the application I was running and would like to thank all for their response, will use this forum again. 🙂🙂

SGIII

Level 8

35,372 points

May 23, 2015 8:08 PM in response to GeorgemcS

Missed the earlier "debate" about Numbers:)

Have you have noticed that every column in Numbers is a named range?

This feature becomes more apparent if you turn on 'Use header names as labels' in Numbers > Preferences:

And then...

Have a look at some of the templates (accessible from Template Chooser at File > New).

Or try an example like this:

... But you don't have to have 'Use header names as labels' turned on for columns to behave like named ranges.

Using a combination of small, discrete tables (rather than one big sheet as is common in Excel) and taking advantage of this built-in feature can be very powerful, more convenient than Excel for some things.

Can I use Names for a group of cells in Numbers