Dynamic List

[stevewilde]

is it possible to have an dynamic list, so that when I add in a new entry in to the input column, the output column will automatically change to the same thing. Also then my dropdown will realise a new entry has been inputted (uses the output list) and the list will update to show this.

Thanks

[NBVC]

Use simple formula in F5:

=IF(D5="","",D5) copied down and extended as far as you want

Then, change Named Range for Output to:

=OFFSET(Sheet1!$F$5:$F$9,0,0,COUNTIF(Sheet1!$F$5:$F$9,"*?"),1)

if entries are text...

or

=OFFSET(Sheet1!$F$5:$F$9,0,0,COUNT(Sheet1!$F$5:$F$9),1)

if entries are numbers...

[stevewilde]

Use simple formula in F5:

=IF(D5="","",D5) copied down and extended as far as you want

Then, change Named Range for Output to:

=OFFSET(Sheet1!$F$5:$F$9,0,0,COUNTIF(Sheet1!$F$5:$F$9,"*?"),1)

if entries are text...

or

=OFFSET(Sheet1!$F$5:$F$9,0,0,COUNT(Sheet1!$F$5:$F$9),1)

if entries are numbers...

That's great worked a treat - many thanks