Creating list with different cell range
 

Is it possible to create a list referring to non consecutive cells but all
cells in the same column.

eg. i want to create a list only with souce of cells 1 and 3 and 5 in the
below row.

1 a
2 b
3 c
4 d
5 e

please help.

Creating list with different cell range
 

1 A 1 =INDIRECT("B"&C1)
2 B =C1+2 =INDIRECT("B"&C2)
3 C =C2+2 =INDIRECT("B"&C3)
4 D =C3+2
5 E


"sriya" wrote:

Is it possible to create a list referring to non consecutive cells but all
cells in the same column.

eg. i want to create a list only with souce of cells 1 and 3 and 5 in the
below row.

1 a
2 b
3 c
4 d
5 e

please help.

Creating list with different cell range
 

thanks for the reply...but i dont think it answered my question. I want to
create a list eg. only with values a,c,d in the list. So will it allow me to
leave b and d and select only alternative cells as the source? Its giving me
an error saying union and intersection is not possible.

"dhstein" wrote:

1 A 1 =INDIRECT("B"&C1)
2 B =C1+2 =INDIRECT("B"&C2)
3 C =C2+2 =INDIRECT("B"&C3)
4 D =C3+2
5 E


"sriya" wrote:

Is it possible to create a list referring to non consecutive cells but all
cells in the same column.

eg. i want to create a list only with souce of cells 1 and 3 and 5 in the
below row.

1 a
2 b
3 c
4 d
5 e

please help.

Creating list with different cell range
 

I thought you wanted every cell as in your original question - cells in rows
1,3,5. The formulas I gave you will do that. I may not understand what
you're trying to do.

"sriya" wrote:

thanks for the reply...but i dont think it answered my question. I want to
create a list eg. only with values a,c,d in the list. So will it allow me to
leave b and d and select only alternative cells as the source? Its giving me
an error saying union and intersection is not possible.

"dhstein" wrote:

1 A 1 =INDIRECT("B"&C1)
2 B =C1+2 =INDIRECT("B"&C2)
3 C =C2+2 =INDIRECT("B"&C3)
4 D =C3+2
5 E


"sriya" wrote:

Is it possible to create a list referring to non consecutive cells but all
cells in the same column.

eg. i want to create a list only with souce of cells 1 and 3 and 5 in the
below row.

1 a
2 b
3 c
4 d
5 e

please help.

Creating list with different cell range
 

Think you need to extract it into another range,
then use that range as the source for downstreams

Eg you could place in B1: =INDEX(A$1:A$5,ROW()*2-1)
and copy down to B3, then use/point to B1:B3 as the "derived" source list
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"sriya" wrote:
thanks for the reply...but i dont think it answered my question. I want to
create a list eg. only with values a,c,d in the list. So will it allow me to
leave b and d and select only alternative cells as the source? Its giving me
an error saying union and intersection is not possible.