LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Auto Filter Comma Dilemiation

I have a spreadsheet and I would like to be able to limit the number of
columns by using comma separations. If I have Column B and it has a list of
10 rows with numbers or text in there, separated by commas, how do I filter
it with auto filter?

For example. Column B, Row 1 has 4,5. Column B, Row 2 has 2,3,4, and Column
B Row 3 has 5,6,3. I'd like it to pick that apart in auto filter to show a
list of 2 -- 3 -- 4 -- 5 -- 6 instead of: 4,5 -- 2,3,4 -- 5,6,3. Then when I
filter it by selecting the 4, it would show all the rows with 4 in it.

If anyone knows of a way to do this please respond!

Thanks
 
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
Excel auto-filter does not filter certain columns Eric_NY Excel Discussion (Misc queries) 5 November 29th 08 10:13 AM
DataFilterAuto Filter in excel 2007? TIJ New Users to Excel 2 November 13th 08 03:28 AM
Excel 2007 Auto Filter Filter Django Excel Discussion (Misc queries) 2 September 9th 08 10:52 PM
Open CSV file auto delimites using space not comma Andy Dale Excel Discussion (Misc queries) 2 July 11th 08 09:15 PM
Excel auto filter doesn't recoginize case - won't filter AA from A Mikey Excel Discussion (Misc queries) 1 September 29th 05 08:18 PM


All times are GMT +1. The time now is 06:54 PM.

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

About Us

"It's about Microsoft Excel"