PC Review


Reply
Thread Tools Rate Thread

Data validation - drop down list

 
 
Oscar
Guest
Posts: n/a
 
      18th Feb 2010
When I use column of data as source for list of allowed values it does not
give me unique values (like AutoFilter does for example). I get the same
value as many times as it appers in list source.

The other problem is that values in a list are not sorted as they are in
AutoFilter.

Looking at the questions in Excel User Goups I can see many users see this
as a problem...

Regards, Oscar.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop down/data validation list Bermie Microsoft Excel Misc 5 2nd Apr 2010 07:32 PM
DATA VALIDATION/DROP DOWN LIST Anya Blue Microsoft Excel Worksheet Functions 1 11th Sep 2009 07:03 PM
Data Validation using List (But needs unique list in drop down lis =?Utf-8?B?VGFu?= Microsoft Excel New Users 1 8th Jul 2005 03:32 PM
Drop down list for Data Validation jlbreyer Microsoft Excel Misc 3 1st Sep 2004 11:42 PM
Data Validation drop-down list does not appear Barbara Microsoft Excel Misc 12 11th Dec 2003 05:24 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:34 AM.