VBA Advanced Filter unexpected result

[vcto]

I query a large database for errors between .301 and .31, class G. There are errors of class G+, which I don't need.

Criteria
A B C
2 Error Error Class
3 >.301 <.31 G


Code
Sub AdvFilter01()
Sheets("TestResults 2011-10").Range("A1:AR90000"). _
AdvancedFilter xlFilterCopy, _
Sheets("Filter01").Range("A2:C3"), _
Sheets("Filter01").Range("A6:B6")
End Sub

Output
A B
6 Error Class
7 0.303 G
8 0.302 G
9 0.304 G
10 0.306 G
11 0.302 G+
12 0.303 G+

Why am I getting G+?

Thank you,
vcto

 

[pgc01]

Hi
Welcome to the board

If you specify

Class
G

This means you want strings starting with G.

If you just want the letter G then 3 options:

With the cell formatted as general use one of the 2

="=G"
or
'=G

or with the cell formatted as text use

=G

 

[vcto]

Hi PGC01,

I tried all 3 methods and they work. Thank you!
vcto

 

[pgc01]

I'm glad it helped. Thanks for the feedback.