#1
|
|||
|
|||
Data Validation drop down
Hai,
I have a worksheet with Column A as a calculated filed. It is formatted to Integer. It has numbers starting from 1 till 50 and will keep on increase when ever a row is inserted. But it is not in sequence or sorted. I do have a validation drop-down list in the second sheet and I want to the drop down list pick the data from my first sheet column A and like to have a continous number from the Min(Column A) to Max(Column A) in the drop down list. I mean, if the Min(Column A)=1 and Max(Column A)=12, my drop-down should show 1,2,3,4 . . . . . till 12. I tried to use drop down with OffSet function, I am getting 1, 5, 6, 7, 9,11 . . . like that. So if I want to select 3 or 4 in the drop-down list, it is not there, because it is not in Column A. Is there any function, code or method available to get a continuous number series in drop-down starting from Min() till Max() values of a column? Thank you very much for your help |
#2
|
||||
|
||||
Could you post a sample sheet?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Tags |
data validation |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
If/then formulas with data validation | shira47 | Excel | 1 | 04-09-2012 05:14 AM |
Data validation using indirect function | BullMouse | Excel | 2 | 11-30-2011 05:25 PM |
Data validation with IF | Klyxrastafari | Excel | 1 | 10-03-2011 04:41 PM |
Conditional data validation (list drop-down) | click4akshay | Excel | 2 | 04-28-2011 01:51 PM |
Trouble With Data Validation And Filtering On A Dropdown | zura04 | Excel | 0 | 10-24-2006 12:54 PM |