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