Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I Make AutoFilter to be Case-Sensitive?
I am using Excel 2003 SP3.
I have a column of text that contains several unique values: AcmeCompany Acme Company ACME COMPANY I want the user to see how many versions of their company name they have in this column. I want to see all these entries in the auto-filter drop down, but I only see the first two because of their spelling. Is there any way I can accomplish this using autofilter? Any other ideas for displaying this information to a user in a simple way? I want to actually select the entire record that uses a particular spelling, too, otherwise I would use Advanced Filter. Thanks. Jen G |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I Make AutoFilter to be Case-Sensitive?
Hi
Take a look at the FastFilter utility that I wrote, which is available at http://www.contextures.com/Fastfilter.zip or http://excelusergroup.org/files/fold...entry1194.aspx You can type Acme* in the row above the filter, and all three different versions will show up. -- Regards Roger Govier "jgraves" wrote in message ... I am using Excel 2003 SP3. I have a column of text that contains several unique values: AcmeCompany Acme Company ACME COMPANY I want the user to see how many versions of their company name they have in this column. I want to see all these entries in the auto-filter drop down, but I only see the first two because of their spelling. Is there any way I can accomplish this using autofilter? Any other ideas for displaying this information to a user in a simple way? I want to actually select the entire record that uses a particular spelling, too, otherwise I would use Advanced Filter. Thanks. Jen G |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I Make AutoFilter to be Case-Sensitive?
Roger, this is a truly nifty utility! I can picture other uses for it, but
this situation doesn't quite fit. I need to be able to see each unique value in the auto-filter drop down. Your utility will not show me this, unless I am missing something in your instructions. Thanks, Jen "Roger Govier" wrote: Hi Take a look at the FastFilter utility that I wrote, which is available at http://www.contextures.com/Fastfilter.zip or http://excelusergroup.org/files/fold...entry1194.aspx You can type Acme* in the row above the filter, and all three different versions will show up. -- Regards Roger Govier "jgraves" wrote in message ... I am using Excel 2003 SP3. I have a column of text that contains several unique values: AcmeCompany Acme Company ACME COMPANY I want the user to see how many versions of their company name they have in this column. I want to see all these entries in the auto-filter drop down, but I only see the first two because of their spelling. Is there any way I can accomplish this using autofilter? Any other ideas for displaying this information to a user in a simple way? I want to actually select the entire record that uses a particular spelling, too, otherwise I would use Advanced Filter. Thanks. Jen G |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I Make AutoFilter to be Case-Sensitive?
Sorry Jen
Misread your question. There is no way that you can get the Autofilter dropdown to distinguish between cases. The lack of a space, is different, and that will show as one entry, but the others, be they in lower or uppercase will only show once. -- Regards Roger Govier "jgraves" wrote in message ... Roger, this is a truly nifty utility! I can picture other uses for it, but this situation doesn't quite fit. I need to be able to see each unique value in the auto-filter drop down. Your utility will not show me this, unless I am missing something in your instructions. Thanks, Jen "Roger Govier" wrote: Hi Take a look at the FastFilter utility that I wrote, which is available at http://www.contextures.com/Fastfilter.zip or http://excelusergroup.org/files/fold...entry1194.aspx You can type Acme* in the row above the filter, and all three different versions will show up. -- Regards Roger Govier "jgraves" wrote in message ... I am using Excel 2003 SP3. I have a column of text that contains several unique values: AcmeCompany Acme Company ACME COMPANY I want the user to see how many versions of their company name they have in this column. I want to see all these entries in the auto-filter drop down, but I only see the first two because of their spelling. Is there any way I can accomplish this using autofilter? Any other ideas for displaying this information to a user in a simple way? I want to actually select the entire record that uses a particular spelling, too, otherwise I would use Advanced Filter. Thanks. Jen G |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I Make AutoFilter to be Case-Sensitive?
Could you use a helper column with a formula in it?
If yes, you could put: =a2<substitute(a2,"ACME","") If you see true, then A2 contains the uppercase ACME characters. =substitute() is case sensitive, so if A2 contains ACME (all uppercase), then =substitute(a2,"ACME","") will be different than the original string in A2. If ACME isn't in A2, then the =substitute() won't change the original string. Then drag it down the column and filter by true/false. jgraves wrote: I am using Excel 2003 SP3. I have a column of text that contains several unique values: AcmeCompany Acme Company ACME COMPANY I want the user to see how many versions of their company name they have in this column. I want to see all these entries in the auto-filter drop down, but I only see the first two because of their spelling. Is there any way I can accomplish this using autofilter? Any other ideas for displaying this information to a user in a simple way? I want to actually select the entire record that uses a particular spelling, too, otherwise I would use Advanced Filter. Thanks. Jen G -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I Make AutoFilter to be Case-Sensitive?
You can distinguish between upper and non-upper case by using a helper
column with the formula: =a2=upper(a2) This will give you True if a2 is in all upper case, and false if not. Now you can filter for it. Regards. Fred "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Sorry Jen Misread your question. There is no way that you can get the Autofilter dropdown to distinguish between cases. The lack of a space, is different, and that will show as one entry, but the others, be they in lower or uppercase will only show once. -- Regards Roger Govier "jgraves" wrote in message ... Roger, this is a truly nifty utility! I can picture other uses for it, but this situation doesn't quite fit. I need to be able to see each unique value in the auto-filter drop down. Your utility will not show me this, unless I am missing something in your instructions. Thanks, Jen "Roger Govier" wrote: Hi Take a look at the FastFilter utility that I wrote, which is available at http://www.contextures.com/Fastfilter.zip or http://excelusergroup.org/files/fold...entry1194.aspx You can type Acme* in the row above the filter, and all three different versions will show up. -- Regards Roger Govier "jgraves" wrote in message ... I am using Excel 2003 SP3. I have a column of text that contains several unique values: AcmeCompany Acme Company ACME COMPANY I want the user to see how many versions of their company name they have in this column. I want to see all these entries in the auto-filter drop down, but I only see the first two because of their spelling. Is there any way I can accomplish this using autofilter? Any other ideas for displaying this information to a user in a simple way? I want to actually select the entire record that uses a particular spelling, too, otherwise I would use Advanced Filter. Thanks. Jen G |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I Make AutoFilter to be Case-Sensitive?
I bet you meant to suggest the =exact() function:
=exact(a2,upper(a2)) Fred Smith wrote: You can distinguish between upper and non-upper case by using a helper column with the formula: =a2=upper(a2) This will give you True if a2 is in all upper case, and false if not. Now you can filter for it. Regards. Fred "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Sorry Jen Misread your question. There is no way that you can get the Autofilter dropdown to distinguish between cases. The lack of a space, is different, and that will show as one entry, but the others, be they in lower or uppercase will only show once. -- Regards Roger Govier "jgraves" wrote in message ... Roger, this is a truly nifty utility! I can picture other uses for it, but this situation doesn't quite fit. I need to be able to see each unique value in the auto-filter drop down. Your utility will not show me this, unless I am missing something in your instructions. Thanks, Jen "Roger Govier" wrote: Hi Take a look at the FastFilter utility that I wrote, which is available at http://www.contextures.com/Fastfilter.zip or http://excelusergroup.org/files/fold...entry1194.aspx You can type Acme* in the row above the filter, and all three different versions will show up. -- Regards Roger Govier "jgraves" wrote in message ... I am using Excel 2003 SP3. I have a column of text that contains several unique values: AcmeCompany Acme Company ACME COMPANY I want the user to see how many versions of their company name they have in this column. I want to see all these entries in the auto-filter drop down, but I only see the first two because of their spelling. Is there any way I can accomplish this using autofilter? Any other ideas for displaying this information to a user in a simple way? I want to actually select the entire record that uses a particular spelling, too, otherwise I would use Advanced Filter. Thanks. Jen G -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I Make AutoFilter to be Case-Sensitive?
Thanks, Dave. Good catch. Fred.
"Dave Peterson" wrote in message ... I bet you meant to suggest the =exact() function: =exact(a2,upper(a2)) Fred Smith wrote: You can distinguish between upper and non-upper case by using a helper column with the formula: =a2=upper(a2) This will give you True if a2 is in all upper case, and false if not. Now you can filter for it. Regards. Fred "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Sorry Jen Misread your question. There is no way that you can get the Autofilter dropdown to distinguish between cases. The lack of a space, is different, and that will show as one entry, but the others, be they in lower or uppercase will only show once. -- Regards Roger Govier "jgraves" wrote in message ... Roger, this is a truly nifty utility! I can picture other uses for it, but this situation doesn't quite fit. I need to be able to see each unique value in the auto-filter drop down. Your utility will not show me this, unless I am missing something in your instructions. Thanks, Jen "Roger Govier" wrote: Hi Take a look at the FastFilter utility that I wrote, which is available at http://www.contextures.com/Fastfilter.zip or http://excelusergroup.org/files/fold...entry1194.aspx You can type Acme* in the row above the filter, and all three different versions will show up. -- Regards Roger Govier "jgraves" wrote in message ... I am using Excel 2003 SP3. I have a column of text that contains several unique values: AcmeCompany Acme Company ACME COMPANY I want the user to see how many versions of their company name they have in this column. I want to see all these entries in the auto-filter drop down, but I only see the first two because of their spelling. Is there any way I can accomplish this using autofilter? Any other ideas for displaying this information to a user in a simple way? I want to actually select the entire record that uses a particular spelling, too, otherwise I would use Advanced Filter. Thanks. Jen G -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Case sensitive filtering | Excel Discussion (Misc queries) | |||
Getting a case sensitive match? | Excel Worksheet Functions | |||
Case Sensitive w/ IF | Excel Worksheet Functions | |||
can vlookup be forced to make a case sensitive match? | Excel Discussion (Misc queries) | |||
any way to make vlookup case sensitive? | Excel Worksheet Functions |