Autofilter

  • Thread starter Thread starter Antonio Bustamante
  • Start date Start date
A

Antonio Bustamante

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
 
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
 
Hi Antonio,
What I need to select "contains" and see the number 54?
I apreciate any help
Click to expand...

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
 
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"


.
Click to expand...
 
Back
Top