Advance Fileter

[elgringo56]

OK, once again my ignorance shows. I wish to filter/copy a list for the value MM1 located in one of the columns. I do not want the filter to display or find MM10, MM11, MM12........MM19. I have tried clicking on unique records only, thats doesn't do it. Is there any way to make what I want happen?

[Mark W.]

On 2002-05-08 14:57, elgringo56 wrote:
OK, once again my ignorance shows. I wish to filter/copy a list for the value MM1 located in one of the columns. I do not want the filter to display or find MM10, MM11, MM12........MM19. I have tried clicking on unique records only, thats doesn't do it. Is there any way to make what I want happen?

I assume you're using an Advanced AutoFilter with a Criteria. I'm I correct?

[elgringo56]

Yes, the criteria is just two cells, the first gives the header name and the second the value MM1. the column is up to 10000 cells long and can contain many MM1XX entries but I only want the one, MM1. I am pulling my hair out

[Aladin Akyurek]

On 2002-05-08 14:57, elgringo56 wrote:
OK, once again my ignorance shows. I wish to filter/copy a list for the value MM1 located in one of the columns. I do not want the filter to display or find MM10, MM11, MM12........MM19. I have tried clicking on unique records only, thats doesn't do it. Is there any way to make what I want happen?

Lets say that A4: houses the following sample;

{"field1","field2";
"MM10","q";
"MM11","s";
"MM1","c";
"MM19","v"}

Format row 4 distinctively, eg., in bold and italic.

In A2 enter:

=A5="MM1"

Activate A5.
Activate Data|Filter|Advanced Filter.

Enter $A$1:$A$2 for "Criteria range".

Fill in the rest as it suits.



[ This Message was edited by: Aladin Akyurek on 2002-05-08 15:12 ]

[Mark W.]

On 2002-05-08 15:09, elgringo56 wrote:
Yes, the criteria is just two cells, the first gives the header name and the second the value MM1. the column is up to 10000 cells long and can contain many MM1XX entries but I only want the one, MM1. I am pulling my hair out

Use ="=MM1" in your criteria instead of "MM1".

[elgringo56]

Hmmmmm, I dont mean to sound totally ignorant, but what you gave me does not compute in my pea brain. Looks like all greek to me. thank you for trying, though. Guess I will never figure this stuff out.

[Aladin Akyurek]

On 2002-05-08 15:20, elgringo56 wrote:
Hmmmmm, I dont mean to sound totally ignorant, but what you gave me does not compute in my pea brain. Looks like all greek to me. thank you for trying, though. Guess I will never figure this stuff out.

Are you referring to the procedure I (partly) described and want me to fill in in more detail?

[elgringo56]

Yes, Aladin, and Mark, that ="=MM1" worked, althought I dont know why

[elgringo56]

Oh, I think I do understand it. The "=MM1" portion says that it is a unique entry and the first = says it must equal that entry exact. would this be correct thinking? Thanks greatly guys for the help

[Aladin Akyurek]

On 2002-05-08 15:26, elgringo56 wrote:
Yes, Aladin, and Mark, that ="=MM1" worked, althought I dont know why

So you're done then?

BTW,

(1)

{"field1";"=MM1"}

has the same effect as

(2)

{"";=A5="MM1"}

in my formulation of the criteria. The parser for the Advanced Filter interprets (1) as a test for the values under "field1" and (2) as a test for all values in A from A5 on.

Aladin