Sleeper: Searching, Autofilter, Double Input

[newk]

Hi,

I have a spreadsheet with a column that stores peoples initials and occassionally names.

For example:
E14 : 'DO'
E15 : 'DO, KN'

Now when I apply an autofilter it will offer me two choices 'DO' and 'DO, KN'.

I would like it to return two choices; 'DO' & 'KN'.

How can I input two seperate values into a cell and it register that they are two values.

Please help, thank you

newk

[newk]

Has anyone used MS Project? What I need is the same sort of function as that on the 'resource' column of the gantt chart view.

I've seen it done before in Excel. Something like ='DO', 'KN'

Please help...anyone

[Zack Barresse]

Choose custom on the drop down, use the OR feature. You are allowed two criteria's for AutoFilter.