Auto Filter, Wilcards and Numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a spreadsheet I have a colum full of numerical values like this:

0.016666667
0.033333333
0.05
0.066666667
1.016666667
1.233333333
1.25
44.28333333
44.3
44.01666667



These numbers go down for nearly 3000 rows. I want to be able to run an
autofilter on anything that ends in ??.016666667

However...it just wont let me do it. When I try to use wild cards or choose
'ends with', it always returns no results.

any ideas?
 
Create a helper column with following formula:
=MOD(A1,1)=0.016666667

Then autofilter for TRUE

HTH
 
You must log in or register to reply here.

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

Auto Filter returns no results 2
Auto-filter selection 1
Filter not working as expected 3
Filtering 1
Problems with Auto Filter 2
List similar to Auto-Filter's? 7
Auto Filter Comma Dilemiation 2
Excel 2003 1

Back
Top