![]() |
#1
|
|||
|
|||
![]()
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?
__________________
Using O365 v2503 - 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 | Thread Starter | Forum | Replies | Last Post |
If/then formulas with data validation | shira47 | Excel | 1 | 04-09-2012 05:14 AM |
![]() |
BullMouse | Excel | 2 | 11-30-2011 05:25 PM |
Data validation with IF | Klyxrastafari | Excel | 1 | 10-03-2011 04:41 PM |
![]() |
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 |