Auto filter custom filter

S

stevefromnaki

Hi,

I have applied an autofilter to my data. I want to do a custom filter from
there.

My data is as follows:
100
110
120
200
210
220
300
....
900
910
920

The 100, 200, etc levels are the total categories and i need to do a custom
filter based on if the number from the list is a "hundred" number. E.g. 100,
200, 300 ... , 900 I.e. the middle digit is only 0, or the whole number is a
round 100, 200, 300, etc level number...

Thanks in advance,
stevefromnaki
 
M

Ms-Exl-Learner

Assume that you are having the values in ColumnA like the below:-

A Col
100
110
120
200
210
220
300
…
900
910
920

In B1 cell paste the below formula

=IF(ISNUMBER(A1),IF(AND(A1>=100,A1<=900,VALUE(RIGHT(A1,2))=0),"YES","NO"),"")

Now copy the B1 cell and paste it to the remaining cells of B Column depends
upon the A Column data.

Now apply the filter for B Column and select Yes.

Remember to Click Yes, if this post helps!
 
S

stevefromnaki

That will work, but is there a way to do it without adding in an extra
column, i already have about 30 columns ;)
 

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

Top