Data filter brings in too much data

G

Guest

I have a simple macro that is supposed to filer out the rows where the first
column contains the string "TC1". The other rows in the data range contain
the string "TC1 APR05", "TCI May05", "TC2" etc. The problem is that when I
specify the filter criteria as "TC1" the results include all the rows that
include TC1 as the first 3 characters. this will include TC1 May05 etc. How
can I limit the filter to extract just the rows that contain "TC1" and only
"TC1" irrespective of the characters that follow.
Thank you
 
N

Norman Jones

Hi Ben,

To restrict the filter output to TC1 rather than all strings which start
with TC1, try changing your filter criterion to:

="=TC1"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Too much data for this code? 4
How to copy row data from Sheet2 to Sheet1 based on Conditional Date 2
Neat code for pasting filtered data to a separate worksheet 10
Dynamic Data Range from External Text File, Filter 2
In Excel my autofilter? is omitting some data rows from output 1
Filter and Copy? 3
COPY PASTE with FILTER copies anti-filtered results as hidden rows 2
questions on advanced filter 4

Top