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.