Thread: filters
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Pascale Pascale is offline
external usenet poster
 
Posts: 78
Default filters

I was not able to get this working, but i just noticed by excel is in
french!!!Is there a french version for help on line? or do you know the
french translation of this formula?

"Max" wrote:

One way is to use autofilter on a helper col
Assuming the numbers (606, 607, 608, etc) are running in B2 down
Place in say, E2: = --ISNUMBER(MATCH(B2,{606;607;608},0))
Copy E2 down to the last row of data in col B
Then autofilter col E for: 1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Pascale" wrote:
Hello I have a sales pipeline, and I would like to filter more then two items
at a time.

In other words, I have a filter with # 606-607-608-605-804-805-594-596
ect.... I would like to personalixe a filter to extract #606-607-and 608 for
example. How can I do that?

Pascale