Thread: filters
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default filters

Change your news reader to Outlook Express and use msnews.microsoft.com as
server

microsoft.public.fr.excel wil get you a French newsgroup.


Gord Dibben MS Excel MVP

On Mon, 11 Feb 2008 05:33:03 -0800, Pascale
wrote:

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