Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto filter custom filter
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto filter custom filter
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(RIGH T(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! -------------------- (Ms-Exl-Learner) -------------------- "stevefromnaki" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto filter custom filter
That will work, but is there a way to do it without adding in an extra
column, i already have about 30 columns ;) "Ms-Exl-Learner" wrote: 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(RIGH T(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! -------------------- (Ms-Exl-Learner) -------------------- "stevefromnaki" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Auto Filter | Excel Discussion (Misc queries) | |||
Custom auto filter (Dates) | Excel Worksheet Functions | |||
Auto filter by (ALL) custom from other sheet. | Excel Worksheet Functions | |||
Does anyone know how to tweak Custom Auto Filter box? | New Users to Excel | |||
Auto-Filter-Custom Problem | Excel Discussion (Misc queries) |