Data Validation

[How_Do_I]

I can't sort this out, I must be selecting something incorrectly from the DV options...

Instead of putting 1 - 24 in 24 cells and using that as a DV List, how can I make my DV cell show 1 - 24 (the 24 numbers)... do I need 1 in a box and 24 in a box... Where am I going wrong please?

 

[GlennUK]

You could put this in the list definition:
1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24

 

[Mike Blackman]

A little confused on what you want here....

Maybe,

1,2,3,4,5,6,7,8,9,..........

Or

1 - 24,Something Else,Somethign Else,.......

 

[How_Do_I]

Thanks Glenn, that got it. I tried to use "whole numbers" and "between" in DV but couldn't get it working... Your solution will do as it'll save "worksheet real estate"...

 

[GlennUK]

Thanks Glenn, that got it. I tried to use "whole numbers" and "between" in DV but couldn't get it working... Your solution will do as it'll save "worksheet real estate"...

That's great!