AutoFilter: custom filter hides all
 

I have a column that contains number/letter format 100ABC, 101DEF, etc. When
I do a custom filter to show all the cells that contain 100, etc., the entire
column hides. How do I get it to show the cells I want to see?
Thanks....TomCat

AutoFilter: custom filter hides all
 

Hi

Autofilter dropdownCustomBegins with100

--
Regards
Roger Govier

"TomCat" wrote in message
...
I have a column that contains number/letter format 100ABC, 101DEF, etc.
When
I do a custom filter to show all the cells that contain 100, etc., the
entire
column hides. How do I get it to show the cells I want to see?
Thanks....TomCat

AutoFilter: custom filter hides all
 

Didn't work. Still hides the entire column.

"Roger Govier" wrote:

Hi

Autofilter dropdownCustomBegins with100

--
Regards
Roger Govier

"TomCat" wrote in message
...
I have a column that contains number/letter format 100ABC, 101DEF, etc.
When
I do a custom filter to show all the cells that contain 100, etc., the
entire
column hides. How do I get it to show the cells I want to see?
Thanks....TomCat

AutoFilter: custom filter hides all
 

Hi

If you want to mail me a copy of the workbook direct, then I will take a
look.
To mail direct, send to
roger at technology4u dot co dot uk
Change the at and dots to make valid email address

--
Regards
Roger Govier

"TomCat" wrote in message
...
Didn't work. Still hides the entire column.

"Roger Govier" wrote:

Hi

Autofilter dropdownCustomBegins with100

--
Regards
Roger Govier

"TomCat" wrote in message
...
I have a column that contains number/letter format 100ABC, 101DEF, etc.
When
I do a custom filter to show all the cells that contain 100, etc., the
entire
column hides. How do I get it to show the cells I want to see?
Thanks....TomCat

AutoFilter: custom filter hides all
 

File received and returned.

The Values were numeric 100314 etc., not Text 100ABC as first posted, hence
begins with wouldn't work.
Setting criteria to
100000
and
<101000
gives a list of all values that are 6 digit and begin with 100
--
Regards
Roger Govier

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi

If you want to mail me a copy of the workbook direct, then I will take a
look.
To mail direct, send to
roger at technology4u dot co dot uk
Change the at and dots to make valid email address

--
Regards
Roger Govier

"TomCat" wrote in message
...
Didn't work. Still hides the entire column.

"Roger Govier" wrote:

Hi

Autofilter dropdownCustomBegins with100

--
Regards
Roger Govier

"TomCat" wrote in message
...
I have a column that contains number/letter format 100ABC, 101DEF,
etc.
When
I do a custom filter to show all the cells that contain 100, etc., the
entire
column hides. How do I get it to show the cells I want to see?
Thanks....TomCat