Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
How do I filter names using only the first letter?
I am trying to filter a list of names using only the first letter. How do I
go about setting this up? |
#2
|
|||
|
|||
Try using a helper column, If your data were in column A, in column B enter
=LEFT(A1,1) and drag down to the end of your data list in column A, then sort by column B Regards, Alan. "Mr_Sparkly" wrote in message ... I am trying to filter a list of names using only the first letter. How do I go about setting this up? |
#3
|
|||
|
|||
On Sun, 17 Jul 2005 01:06:30 +0100, "Alan"
wrote: Try using a helper column, If your data were in column A, in column B enter =LEFT(A1,1) and drag down to the end of your data list in column A, then sort by column B Regards, Alan. "Mr_Sparkly" wrote in message ... I am trying to filter a list of names using only the first letter. How do I go about setting this up? Did he mean sort? He said filter.. (Actually a serious question..) MP -- "Learning is a behavior that results from consequences." B.F. Skinner |
#4
|
|||
|
|||
He did indeed, error on my part. Doesn't really make any difference though,
Filter by column B, not sort by column B Regards, Alan. "Mangus Pyke" wrote in message ... On Sun, 17 Jul 2005 01:06:30 +0100, "Alan" wrote: Try using a helper column, If your data were in column A, in column B enter =LEFT(A1,1) and drag down to the end of your data list in column A, then sort by column B Regards, Alan. "Mr_Sparkly" wrote in message ... I am trying to filter a list of names using only the first letter. How do I go about setting this up? Did he mean sort? He said filter.. (Actually a serious question..) MP -- "Learning is a behavior that results from consequences." B.F. Skinner |
#5
|
|||
|
|||
On Sun, 17 Jul 2005 01:27:09 +0100, "Alan"
wrote: He did indeed, error on my part. Doesn't really make any difference though, Filter by column B, not sort by column B Regards, Alan. Cool.. he can also use wildcards in his filter or "Begins with" and skip the whole helper column then. Thanks, MP- -- "Learning is a behavior that results from consequences." B.F. Skinner |
#6
|
|||
|
|||
Could do yes, and your advice is valid.
What I think is useful about using a helper column is that once its there, it will show all the first letters of the column it refers to and therefore be available for multiple filtering operations without the need to keep selecting 'Custom' in the filter and entering filter criteria, Regards, Alan. "Mangus Pyke" wrote in message ... On Sun, 17 Jul 2005 01:27:09 +0100, "Alan" wrote: He did indeed, error on my part. Doesn't really make any difference though, Filter by column B, not sort by column B Regards, Alan. Cool.. he can also use wildcards in his filter or "Begins with" and skip the whole helper column then. Thanks, MP- -- "Learning is a behavior that results from consequences." B.F. Skinner |
#7
|
|||
|
|||
On Sat, 16 Jul 2005 16:38:10 -0700, "Mr_Sparkly"
wrote: I am trying to filter a list of names using only the first letter. How do I go about setting this up? Turn on your filter and set it to equal a* (if the letter you want to filter is "a"). You can also, depending on version of Excel, select "Begins with" instead of "Equals" in the filter criteria and use the first letter. The asterisk is a wildcard. -- "Learning is a behavior that results from consequences." B.F. Skinner |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FIRST letter of the names, mi and the whole last name. | Excel Discussion (Misc queries) | |||
First letter of names, mi and last name concat, How? | Excel Discussion (Misc queries) | |||
sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) | |||
Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
How can I find the common names in two columns of names? | Excel Discussion (Misc queries) |