Creating list with different cell range

[sriya]

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.

 

[dhstein]

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]

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]

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.

 

[Max]

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