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
|