LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
AndrewB
 
Posts: n/a
Default select from a fragmented list

how to I limit the data in a drop down list?
ie.
column A has a list of site names, interspersed with month names.
eg. a1 = "Agnew Bros", a2= "Jan", a3="Feb",a4= "Opunake", etc

I've been using a data validation list to pick from, but get all the month
names listed in the pick list.

How do list only the site names in the pick list?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Select a name from a list of employees using Excel Tornado Excel Discussion (Misc queries) 1 January 7th 05 07:45 PM
Extracting Values on one list and not another B Schwarz Excel Discussion (Misc queries) 4 January 7th 05 01:48 PM
Selecting data from a list based on entered values GrantM Excel Discussion (Misc queries) 1 December 20th 04 10:59 AM
select unique to make list Spunky Excel Worksheet Functions 2 November 23rd 04 08:19 PM
Dependent List Query John Excel Worksheet Functions 2 October 28th 04 06:13 PM


All times are GMT +1. The time now is 07:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"