help with filtering

[Susie]

Hi,

How do I use the autofilter to show me three items. It
only seems allow me two when I use the custom filter.

thanks

Susie

 

[Frank Kabel]

Hi
do you mean 3 conditions?. If yes this is not possible with the
autofilter

 

[Barbara Wiseman]

Susie,
Advanced filter may be the answer
http://www.techonthenet.com/excel/filters/advanced2.htm
Barbara