uatt — Fri, 11 Jan 2002 15:18:46 +0000

Sorry I mislead the word filter..
Actually I do it with filter
filter>auto filter
an arrow appear on cell column
I click self-setting(something like that as I use chinese version of excel)
It appears two conditional rows
first row.I chose
condition ending with *22
or
second row
condition ending with *35

now result appear...
This is exactly what I mean with my first post..

sorry for my poor English..

Peter J. Boettcher — Fri, 11 Jan 2002 15:02:47 +0000

Try using the Excel help menu, and search on filter, it should tell you how to use it and where it is.

uatt — Fri, 11 Jan 2002 14:50:44 +0000

I found no filter option there...

Peter J. Boettcher — Fri, 11 Jan 2002 14:37:34 +0000

It depends on what version of Excel you're using, but in Excel 2000 its in the data menu under sort.

uatt — Fri, 11 Jan 2002 14:23:09 +0000

Hi peter
what is filter? and where to click it...

Peter J. Boettcher — Fri, 11 Jan 2002 14:02:42 +0000

I'm not really an excel expert. Did you try using filters?