Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-24-2012, 09:30 AM
rkalapura rkalapura is offline Data Validation drop down Windows 7 64bit Data Validation drop down Office 2007
Novice
Data Validation drop down
 
Join Date: May 2012
Posts: 1
rkalapura is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 05-27-2012, 02:23 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Data Validation drop down Windows 7 64bit Data Validation drop down Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
Reply

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 drop down 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
Data Validation drop down 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:15 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft