Data-Filter on Multiple Entries in Cell

X

XLML

Hi, I am new to the board and using XL2002.

There are instances when I enter more than 1 entry in a cell. Fo
instance, cell A2 can have the 12 months of 2004 separated by
carriage return (Alt-Enter).

When I apply, a Data-Filter-Autofilter on Col A, I would like al
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,
XLM
 
D

Debra Dalgleish

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.
 
X

XLML

I was afraid that it couldn't be done. Thanks for your help Debra an
the workaround suggestion.

XLM
 
Top