LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Burghthing
 
Posts: n/a
Default How do I Auto-Filter with multiple values in a cell in Excel?

Is it possible to use the Auto-Filter in Excel 2003 in the following way:

Cell Value: Requirements, Testing
Cell Value: Requirements
Cell Value: Testing

Is there a way I can enter my cell value such that the Auto-Filter values
will only show "Requirements" and "Testing" in the dropdown, but not
"Requirements, Testing"? I've tried using ; , | and even hard returns as
separators, but to no avail.

Am I asking too much of the auto-filter?

Thanks in advance


 
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
Is there way to enter multiple values into excel cells w/ a form? grassfed Excel Discussion (Misc queries) 1 June 22nd 05 05:26 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
How do I choose multiple values in an excel drop down box? Kristy Excel Discussion (Misc queries) 1 March 31st 05 12:04 AM
Can an excel cell automatically change fill colors based on values John Clark Excel Discussion (Misc queries) 1 February 5th 05 05:21 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 06:27 AM.

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"