Post by **Guest10** » 24 Feb 2014, 22:58

i would like to perform the following in Excel:

Data > Validation > Data Validation > Allow List > Data

in Data field i would like to create a list of values to pick values of other cells. for example, A1, B2, C3, etc. however, this does not work: =A1,=B2,=C3, ... i know, however, a range works such as =A1:A10. but i would like to pick random values from other cells not a range: =A1,=A3,=A5, ... (this never works!). P.S.: Of course an easy/typical application of a list is a simple string of values: apples,oranges,grapes,bananas, ... but I would like to pick values of other random cells.

i would like to perform the following in Excel:

[color=#0000FF]Data > Validation > Data Validation > Allow List > Data[/color]

in Data field i would like to create a list of values to pick values of other cells. for example, A1, B2, C3, etc. however, this does not work: [color=#FF0000]=A1,=B2,=C3, ...[/color] i know, however, a range works such as [color=#FF0000]=A1:A10[/color]. but i would like to pick random values from other cells not a range: [color=#FF0000]=A1,=A3,=A5, ...[/color] ([u]this never works![/u]). P.S.: Of course an easy/typical application of a list is a simple string of values: [color=#0000FF]apples,oranges,grapes,bananas, ...[/color] but I would like to pick values of other random cells.