View Single Post
  #5   Report Post  
Alan
 
Posts: n/a
Default

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