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

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

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

.. french translation of this formula?
.. in say, E2: = --ISNUMBER(MATCH(B2,{606;607;608},0))

Perhaps:
ISNUMBER = ESNUMERO
MATCH = COINCIDIR

so you could try in E2:
--ESNUMERO(COINCIDIR(B2;{606;607;608};0))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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?

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" wrote:

.. french translation of this formula?
.. in say, E2: = --ISNUMBER(MATCH(B2,{606;607;608},0))

Perhaps:
ISNUMBER = ESNUMERO
MATCH = COINCIDIR

so you could try in E2:
--ESNUMERO(COINCIDIR(B2;{606;607;608};0))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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?

.. 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))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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

Since the OP posted in English, and the issue description was clear enough,
thought it was fair game to post a response <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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" wrote:

Since the OP posted in English, and the issue description was clear enough,
thought it was fair game to post a response <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Welcome. glad it turned out ok for you.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---