filters

[Pascale]

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

 

[Max]

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

 

[Pascale]

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]

.. french translation of this formula?
Perhaps:
ISNUMBER = ESNUMERO
MATCH = COINCIDIR

so you could try in E2:
--ESNUMERO(COINCIDIR(B2;{606;607;608};0))

 

[Pascale]

Hello,

the formula is working ok, but now I get a message error : Name(Nom?)

What can be the cause of this and hoe do I correct it?

Pascale

 

[Max]

.. I get a message error : Name(Nom?)

Sorry, think I gave you in the wrong language earlier (spanish)

In French:
ISNUMBER = ESTNUM
MATCH = EQUIV

Try in E2: --ESTNUM(EQUIV(B2;{606;607;608};0))

 

[Gord Dibben]

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

 

[Max]

Since the OP posted in English, and the issue description was clear enough,
thought it was fair game to post a response <g>

 

[Pascale]

Hi there to all.

this was helpfull had no problems understanding. I can work with the english
terminilogy just sometimes I get some particular word formatting that doesnt
work.

This been said, I also do not use outlook express, I have to use Notes the
work mail.

Maybe theres another way to access the french help line, but if not I am ok
like this.

 

[Max]

Welcome. glad it turned out ok for you.