After using a vba module for weeks, I just found out that advanced
filtering doesnt distinguish between Upper and lower case. Is there a
way around this?

My data looks something like this:


UNIT:

A
A
B
B
a

And When I filter for "A" I get
A
A
a

And I want:
A
A

Thanks in advance.