If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Data-Filter on Multiple Entries in Cell
Hi, I am new to the board and using XL2002.
There are instances when I enter more than 1 entry in a cell. For instance, cell A2 can have the 12 months of 2004 separated by a carriage return (Alt-Enter). When I apply, a Data-Filter-Autofilter on Col A, I would like all multiple entries to appear vertically ie: Apr-04 Aug-04 Dec-04 etc... Right now, the dropdown shows: Jan-04 Chr(10) Feb-04 Chr(10) etc... Thanks, XLML --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Data-Filter on Multiple Entries in Cell
The items one cell won't appear on multiple lines in the AutoFilter
dropdown. You could create one record for each month, and repeat the data in the other columns in each record. XLML wrote: Hi, I am new to the board and using XL2002. There are instances when I enter more than 1 entry in a cell. For instance, cell A2 can have the 12 months of 2004 separated by a carriage return (Alt-Enter). When I apply, a Data-Filter-Autofilter on Col A, I would like all multiple entries to appear vertically ie: Apr-04 Aug-04 Dec-04 etc... Right now, the dropdown shows: Jan-04 Chr(10) Feb-04 Chr(10) etc... -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Data-Filter on Multiple Entries in Cell
I was afraid that it couldn't be done. Thanks for your help Debra and
the workaround suggestion. XLML --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Restricting cell data to unique entries? | Jones | General Discussion | 11 | June 23rd, 2004 04:05 PM |
Entering multiple formulas in one cell | Marta | Worksheet Functions | 1 | June 15th, 2004 09:27 PM |
Mial merge data base problems | Rachael | Mailmerge | 16 | May 21st, 2004 06:22 PM |
entering data changes the cell pattern | ozzie_90680 | Worksheet Functions | 2 | September 26th, 2003 09:07 PM |
Multiple Charts from single instance of data | dvt | Charts and Charting | 1 | September 21st, 2003 01:45 PM |