Problem with filter by text box

[sterio]

I have problem when I type any data in text box 1 it doesn’t filter correct for example when I type 8

It filter 8.5k or 8k
I think there is problem in format of size column but I can’t solve it

[Shareez Saleem]

Excel will show all the possibilities which contains the criteria, i.e."8".
If you tried to filter with 8, excel will show you here 8k, 8.5k and 8.5.
If you want filter with 8 only, enter 8 in the filter text box and uncheck the other three.

[mehmetcik]

if you only want to return exact matches only

Why did you add & "*" at the end of your code?

Try

Please Login or Register  to view this content.

[sterio]

still the same problem doesn't solve yet

[Shareez Saleem]

Hi Sterio,

You can filter only with 8 using "Advanced Filter" option under Data Tab.

Steps

1. Add 2 or 3 rows on the tob of your table (only for filtering purpose and you can remove it later).
2. Copy and paste the same title in newly added first row.
3. Give size as 8 as shown in the attachment.
4. Place your cursor on your original table.
5. Click Advance Filter under Data Tab.
6. Select your whole original table as "List Range".
7. Select your new 2 rows as your "Criteria"
8. Click Ok.
Now you can see the filtered data.

Hope this helps.

Please close this Thread as "Resolved" and add reputation if you think the answer is useful.

Regards
Shareez

[Shareez Saleem]

Appreciate if you close this thread using Thread Tools.
If you have further queries related to this subject, please write back to us.

[Terressa]

You have given very well explanation the way use of excel advanced filter.