| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofilter problem
i am using xl 2002 for windows. my autofilter works fine for selecting
a certain catagory, say 99235 or 348851. but if i try to use a Custom filter, specifically "Begins with" then type in 99, it shows nothing. i have tried to use text format, general format, and number format, with the same result....all the rows with data are hidden. what am i overlooking? thanks billy |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autofilter problem
Tonso
Quote from a Dave Peterson posting............ Real numbers won't work the way you want. But if you add a helper column and convert that number number to a text number, you could filter on that helper column. You could use: =text(a2,"0000.000") or =a2&"" to convert to text (depending on what you want to see) End Dave quote....................................... Gord Dibben MS Excel MVP On 17 Nov 2006 13:22:39 -0800, "Tonso" wrote: i am using xl 2002 for windows. my autofilter works fine for selecting a certain catagory, say 99235 or 348851. but if i try to use a Custom filter, specifically "Begins with" then type in 99, it shows nothing. i have tried to use text format, general format, and number format, with the same result....all the rows with data are hidden. what am i overlooking? thanks billy |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autofilter problem
Hi
Could you try Greater than 89999 -- Regards Roger Govier "Tonso" wrote in message oups.com... i am using xl 2002 for windows. my autofilter works fine for selecting a certain catagory, say 99235 or 348851. but if i try to use a Custom filter, specifically "Begins with" then type in 99, it shows nothing. i have tried to use text format, general format, and number format, with the same result....all the rows with data are hidden. what am i overlooking? thanks billy |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autofilter problem
Gord, David...that works fine! Thanks to all who replied!
Tonso Roger Govier wrote: Hi Could you try Greater than 89999 -- Regards Roger Govier "Tonso" wrote in message oups.com... i am using xl 2002 for windows. my autofilter works fine for selecting a certain catagory, say 99235 or 348851. but if i try to use a Custom filter, specifically "Begins with" then type in 99, it shows nothing. i have tried to use text format, general format, and number format, with the same result....all the rows with data are hidden. what am i overlooking? thanks billy |
|
#5
|
|||
|
|||
|
I thought Roger's answer was more logical, actually, FWIW.
Quote:
|
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autofilter problem
Curious
If you are looking for numbers beginning with 99 why is Greater than 89999 logical? That would return all numbers greater than 89999 and miss out numbers like 9902 or 999 To give Roger a break, maybe he meant greater than 98999 and less than 100000 which would return any number from 99000 to 99999 I am assuming 89999 was a typo. Gord On Sat, 18 Nov 2006 23:16:34 +0000, BizMark wrote: I thought Roger's answer was more logical, actually, FWIW. Tonso Wrote: Gord, David...that works fine! Thanks to all who replied! Tonso Roger Govier wrote:- Hi Could you try Greater than 89999 -- Regards Roger Govier "Tonso" wrote in message oups.com...- i am using xl 2002 for windows. my autofilter works fine for selecting a certain catagory, say 99235 or 348851. but if i try to use a Custom filter, specifically "Begins with" then type in 99, it shows nothing. i have tried to use text format, general format, and number format, with the same result....all the rows with data are hidden. what am i overlooking? thanks billy -- |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autofilter problem
Only if the numbers are 5 digit that is
To give Roger a break, maybe he meant greater than 98999 and less than 100000 which would return any number from 99000 to 99999 Gord Curious If you are looking for numbers beginning with 99 why is Greater than 89999 logical? That would return all numbers greater than 89999 and miss out numbers like 9902 or 999 To give Roger a break, maybe he meant greater than 98999 and less than 100000 which would return any number from 99000 to 99999 I am assuming 89999 was a typo. Gord On Sat, 18 Nov 2006 23:16:34 +0000, BizMark wrote: I thought Roger's answer was more logical, actually, FWIW. Tonso Wrote: Gord, David...that works fine! Thanks to all who replied! Tonso Roger Govier wrote:- Hi Could you try Greater than 89999 -- Regards Roger Govier "Tonso" wrote in message oups.com...- i am using xl 2002 for windows. my autofilter works fine for selecting a certain catagory, say 99235 or 348851. but if i try to use a Custom filter, specifically "Begins with" then type in 99, it shows nothing. i have tried to use text format, general format, and number format, with the same result....all the rows with data are hidden. what am i overlooking? thanks billy -- Gord Dibben MS Excel MVP |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autofilter problem
To give Roger a break
Thanks Gord, I needed the break<bg Yes I had meant 98999 and had rather focussed on the OP saying they had said begins with "99". I totally omitted to say an upper limit or that it only applied to 5 digit answers. A hasty and poorly thought out response on my part I am sorry to say. -- Regards Roger Govier "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Only if the numbers are 5 digit that is To give Roger a break, maybe he meant greater than 98999 and less than 100000 which would return any number from 99000 to 99999 Gord Curious If you are looking for numbers beginning with 99 why is Greater than 89999 logical? That would return all numbers greater than 89999 and miss out numbers like 9902 or 999 To give Roger a break, maybe he meant greater than 98999 and less than 100000 which would return any number from 99000 to 99999 I am assuming 89999 was a typo. Gord On Sat, 18 Nov 2006 23:16:34 +0000, BizMark wrote: I thought Roger's answer was more logical, actually, FWIW. Tonso Wrote: Gord, David...that works fine! Thanks to all who replied! Tonso Roger Govier wrote:- Hi Could you try Greater than 89999 -- Regards Roger Govier "Tonso" wrote in message oups.com...- i am using xl 2002 for windows. my autofilter works fine for selecting a certain catagory, say 99235 or 348851. but if i try to use a Custom filter, specifically "Begins with" then type in 99, it shows nothing. i have tried to use text format, general format, and number format, with the same result....all the rows with data are hidden. what am i overlooking? thanks billy -- Gord Dibben MS Excel MVP |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autofilter problem
And a rather hasty first posting by myself.
Pointing out that to use "begins with" on numbers is not possible but neglecting to give OP an alternative to use the custom 98999 and <100000as you did(typo notwithstanding) Gord On Sun, 19 Nov 2006 11:47:20 -0000, "Roger Govier" wrote: To give Roger a break Thanks Gord, I needed the break<bg Yes I had meant 98999 and had rather focussed on the OP saying they had said begins with "99". I totally omitted to say an upper limit or that it only applied to 5 digit answers. A hasty and poorly thought out response on my part I am sorry to say. Gord Dibben MS Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CHANGING POSITION OF AUTOFILTER LIST | Excel Discussion (Misc queries) | |||
| autofilter problem | New Users to Excel | |||
| Excel AutoFilter Problem | Excel Discussion (Misc queries) | |||
| Autofilter problem | Excel Worksheet Functions | |||
| Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Linear Mode
