Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I filter for a blank cell, using custom autofilter | Excel Discussion (Misc queries) | |||
Autofilter Hides All... | Excel Worksheet Functions | |||
custom autofilter | Excel Worksheet Functions | |||
saving autofiltercustom filter settings | Excel Worksheet Functions | |||
Shortcut for Filter- Custom Autofilter | Excel Discussion (Misc queries) |