Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter
What can I do when I have in a database a list of numbers
for example: 54 51 65 63 Then put an autofilter an select (custom) and in the window I select (show rows where) contains, but I can`t see the number 54, only I se if select "equals" but I need always use "contains" What I need to select "contains" and see the number 54? I apreciate any help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter
Do you have a header row at the top. If not, the autofilter is treating the
row with 54 as a header row. Put a header row Header1 54 51 65 63 -- Regards, Tom Ogilvy "Antonio Bustamante" wrote in message ... What can I do when I have in a database a list of numbers for example: 54 51 65 63 Then put an autofilter an select (custom) and in the window I select (show rows where) contains, but I can`t see the number 54, only I se if select "equals" but I need always use "contains" What I need to select "contains" and see the number 54? I apreciate any help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter
Hi Antonio,
What I need to select "contains" and see the number 54? I apreciate any help additionaly to Tom I found that "contains" only works for _text_ and not for numbers. So, if you have numbers in your columns your filter will not work. Change the format of your numbers to text with the TEXT-function, eg. =text(a1;"0;-0;0"). Use help to find out more about that function. best regards arno |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter
Thanks per your help
-----Original Message----- Do you have a header row at the top. If not, the autofilter is treating the row with 54 as a header row. Put a header row Header1 54 51 65 63 -- Regards, Tom Ogilvy "Antonio Bustamante" wrote in message ... What can I do when I have in a database a list of numbers for example: 54 51 65 63 Then put an autofilter an select (custom) and in the window I select (show rows where) contains, but I can`t see the number 54, only I se if select "equals" but I need always use "contains" What I need to select "contains" and see the number 54? I apreciate any help . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter
Thanks for your help I change the numbers to Text, yes work
-----Original Message----- Hi Antonio, What I need to select "contains" and see the number 54? I apreciate any help additionaly to Tom I found that "contains" only works for _text_ and not for numbers. So, if you have numbers in your columns your filter will not work. Change the format of your numbers to text with the TEXT- function, eg. =text(a1;"0;-0;0"). Use help to find out more about that function. best regards arno . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) |