Question on sorting

Select the area with the data.

Click on Data, then Sort

You'll see a drop down menu where you can select Column C

Hope that helps.



"Michael Slater" wrote:

> I have a spreadsheet that contains 3 columns:
>
> Col A = Names
> Col B = Dates of Birth
> Col C = An Assigned Password
>
> The passwords are formatted as follows: A001Z, B002Y, C003X, etc...through
> all rows.
>
> The spreadsheet contains approximately 2300 rows, currently sorted by name.
> I need to sort by Password in the above indicated order.
>
> Anybody have any ideas how his might be done? Or if it's even possible?
>
> Thanks,
>
> Mike
>
>

You need 2 help columns, preferably in D and E

assume you have headers, so in D2

=LEFT(C2)

in E2

=MID(C2,2,3)


copy down by double clicking the lower right corner of E2 after select D2
and E2
then if you want to sort by password sort by the first help column and
secondly the
second help column. If needed create a help column for the last character in
the pw

=RIGHT(C2,1)



--
Regards,

Peo Sjoblom




"Michael Slater" <mslater518 DeleteThis @comcast.net> wrote in message
news:wuadnQRvULhzeCXbnZ2dnUVZ_qKgnZ2d@comcast.com...
>I have a spreadsheet that contains 3 columns:
>
> Col A = Names
> Col B = Dates of Birth
> Col C = An Assigned Password
>
> The passwords are formatted as follows: A001Z, B002Y, C003X, etc...through
> all rows.
>
> The spreadsheet contains approximately 2300 rows, currently sorted by
> name.
> I need to sort by Password in the above indicated order.
>
> Anybody have any ideas how his might be done? Or if it's even possible?
>
> Thanks,
>
> Mike

Hi Peo,

don't you think that the password values (as quoted by the OP) will
sort correctly, without needing helper columns?

Pete

On Aug 7, 11:44 pm, "Peo Sjoblom" <terr... DeleteThis @mvps.org> wrote:
> You need 2 help columns, preferably in D and E
>
> assume you have headers, so in D2
>
> =LEFT(C2)
>
> in E2
>
> =MID(C2,2,3)
>
> copy down by double clicking the lower right corner of E2 after select D2
> and E2
> then if you want to sort by password sort by the first help column and
> secondly the
> second help column. If needed create a help column for the last character in
> the pw
>
> =RIGHT(C2,1)
>
> --
> Regards,
>
> Peo Sjoblom
>
> "Michael Slater" <mslater... DeleteThis @comcast.net> wrote in message
>
> news:wuadnQRvULhzeCXbnZ2dnUVZ_qKgnZ2d@comcast.com...
>
>
>
> >I have a spreadsheet that contains 3 columns:
>
> > Col A = Names
> > Col B = Dates of Birth
> > Col C = An Assigned Password
>
> > The passwords are formatted as follows: A001Z, B002Y, C003X, etc...through
> > all rows.
>
> > The spreadsheet contains approximately 2300 rows, currently sorted by
> > name.
> > I need to sort by Password in the above indicated order.
>
> > Anybody have any ideas how his might be done? Or if it's even possible?
>
> > Thanks,
>
> > Mike- Hide quoted text -
>
> - Show quoted text -

Yes, I thought that myself to begin with, then I realised that he had
posted into the newusers group, so I decided not to read too much into
it.

Pete

On Aug 8, 12:49 am, "Peo Sjoblom" <terr....TakeThisOut@mvps.org> wrote:
> Yes they will, somehow I assumed the OP wouldn't have asked this unless
> there was more to it than meets the eye
>
> --
> Regards,
>
> Peo Sjoblom
>
> "Pete_UK" <pashu....TakeThisOut@auditel.net> wrote in message
>
> news:1186529613.146917.88950@q75g2000hsh.googlegroups.com...
>
>
>
> > Hi Peo,
>
> > don't you think that the password values (as quoted by the OP) will
> > sort correctly, without needing helper columns?
>
> > Pete
>
> > On Aug 7, 11:44 pm, "Peo Sjoblom" <terr....TakeThisOut@mvps.org> wrote:
> >> You need 2 help columns, preferably in D and E
>
> >> assume you have headers, so in D2
>
> >> =LEFT(C2)
>
> >> in E2
>
> >> =MID(C2,2,3)
>
> >> copy down by double clicking the lower right corner of E2 after select D2
> >> and E2
> >> then if you want to sort by password sort by the first help column and
> >> secondly the
> >> second help column. If needed create a help column for the last character
> >> in
> >> the pw
>
> >> =RIGHT(C2,1)
>
> >> --
> >> Regards,
>
> >> Peo Sjoblom
>
> >> "Michael Slater" <mslater....TakeThisOut@comcast.net> wrote in message
>
> >>news:wuadnQRvULhzeCXbnZ2dnUVZ_qKgnZ2d@comcast.com...
>
> >> >I have a spreadsheet that contains 3 columns:
>
> >> > Col A = Names
> >> > Col B = Dates of Birth
> >> > Col C = An Assigned Password
>
> >> > The passwords are formatted as follows: A001Z, B002Y, C003X,
> >> > etc...through
> >> > all rows.
>
> >> > The spreadsheet contains approximately 2300 rows, currently sorted by
> >> > name.
> >> > I need to sort by Password in the above indicated order.
>
> >> > Anybody have any ideas how his might be done? Or if it's even possible?
>
> >> > Thanks,
>
> >> > Mike- Hide quoted text -
>
> >> - Show quoted text -- Hide quoted text -
>
> - Show quoted text -

Yes they will, somehow I assumed the OP wouldn't have asked this unless
there was more to it than meets the eye



--
Regards,

Peo Sjoblom



"Pete_UK" <pashurst DeleteThis @auditel.net> wrote in message
news:1186529613.146917.88950@q75g2000hsh.googlegroups.com...
> Hi Peo,
>
> don't you think that the password values (as quoted by the OP) will
> sort correctly, without needing helper columns?
>
> Pete
>
> On Aug 7, 11:44 pm, "Peo Sjoblom" <terr... DeleteThis @mvps.org> wrote:
>> You need 2 help columns, preferably in D and E
>>
>> assume you have headers, so in D2
>>
>> =LEFT(C2)
>>
>> in E2
>>
>> =MID(C2,2,3)
>>
>> copy down by double clicking the lower right corner of E2 after select D2
>> and E2
>> then if you want to sort by password sort by the first help column and
>> secondly the
>> second help column. If needed create a help column for the last character
>> in
>> the pw
>>
>> =RIGHT(C2,1)
>>
>> --
>> Regards,
>>
>> Peo Sjoblom
>>
>> "Michael Slater" <mslater... DeleteThis @comcast.net> wrote in message
>>
>> news:wuadnQRvULhzeCXbnZ2dnUVZ_qKgnZ2d@comcast.com...
>>
>>
>>
>> >I have a spreadsheet that contains 3 columns:
>>
>> > Col A = Names
>> > Col B = Dates of Birth
>> > Col C = An Assigned Password
>>
>> > The passwords are formatted as follows: A001Z, B002Y, C003X,
>> > etc...through
>> > all rows.
>>
>> > The spreadsheet contains approximately 2300 rows, currently sorted by
>> > name.
>> > I need to sort by Password in the above indicated order.
>>
>> > Anybody have any ideas how his might be done? Or if it's even possible?
>>
>> > Thanks,
>>
>> > Mike- Hide quoted text -
>>
>> - Show quoted text -
>
>

It looks like the first letter of your password increases with each
new one, as does the 3 digit number in the middle, and the final
letter decreases. If this is the case then you want to sort the
password by the 3 digits in the middle to get the order that you want.
Peo's column D is thus not needed - use his formula for column E to
extract the middle three digits and sort on these.

Hope this helps.

Pete

On Aug 8, 12:25 pm, "Michael Slater" <mslater....TakeThisOut@comcast.net> wrote:
> Hi Guys,
>
> Thanks for the advice.
>
> Yes, Peo is correct, in that, just performing a simple sort by the password
> column did not produce the results I was looking for.
>
> I need the sort order results to be sequential by password order. In other
> words, the first password issued was A001Z, the second was B002Y. I have
> over 2000 passwords following this format. A simple sort gives me all
> passwords starting with "A" first, then "B", etc. What I need is the
> original issue order as above, A001Z, B002Y, etc.
>
> I am a new user to Excel, but I am quickly discovering it's many advantages
> and how they can make my job a lot easier. My first, and greatest, problem
> right now is attempting to apply Excel's functionality without having a
> solid background using the program. I have several (large) books, which I
> am currently reading from cover to cover, and always search through them, as
> well as these newsgroups and the internet to try and find an answer before I
> post a question. I try to be as self-sufficient as possible.
>
> The second problem, in this case, is that I inherited this password system,
> which has been used for the last 15+ years, and, had I managed it from the
> beginning, would have kept a copy by Password order.
>
> So, again, thank you, and I will try Peo's sorting method and see what
> results.
>
> Respectfully,
>
> Mike
>
> "Pete_UK" <pashu....TakeThisOut@auditel.net> wrote in message
>
> news:1186530993.125699.326360@19g2000hsx.googlegroups.com...
>
>
>
> > Yes, I thought that myself to begin with, then I realised that he had
> > posted into the newusers group, so I decided not to read too much into
> > it.
>
> > Pete
>
> > On Aug 8, 12:49 am, "Peo Sjoblom" <terr....TakeThisOut@mvps.org> wrote:
> >> Yes they will, somehow I assumed the OP wouldn't have asked this unless
> >> there was more to it than meets the eye
>
> >> --
> >> Regards,
>
> >> Peo Sjoblom
>
> >> "Pete_UK" <pashu....TakeThisOut@auditel.net> wrote in message
>
> >>news:1186529613.146917.88950@q75g2000hsh.googlegroups.com...
>
> >> > Hi Peo,
>
> >> > don't you think that the password values (as quoted by the OP) will
> >> > sort correctly, without needing helper columns?
>
> >> > Pete
>
> >> > On Aug 7, 11:44 pm, "Peo Sjoblom" <terr....TakeThisOut@mvps.org> wrote:
> >> >> You need 2 help columns, preferably in D and E
>
> >> >> assume you have headers, so in D2
>
> >> >> =LEFT(C2)
>
> >> >> in E2
>
> >> >> =MID(C2,2,3)
>
> >> >> copy down by double clicking the lower right corner of E2 after select
> >> >> D2
> >> >> and E2
> >> >> then if you want to sort by password sort by the first help column and
> >> >> secondly the
> >> >> second help column. If needed create a help column for the last
> >> >> character
> >> >> in
> >> >> the pw
>
> >> >> =RIGHT(C2,1)
>
> >> >> --
> >> >> Regards,
>
> >> >> Peo Sjoblom
>
> >> >> "Michael Slater" <mslater....TakeThisOut@comcast.net> wrote in message
>
> >> >>news:wuadnQRvULhzeCXbnZ2dnUVZ_qKgnZ2d@comcast.com...
>
> >> >> >I have a spreadsheet that contains 3 columns:
>
> >> >> > Col A = Names
> >> >> > Col B = Dates of Birth
> >> >> > Col C = An Assigned Password
>
> >> >> > The passwords are formatted as follows: A001Z, B002Y, C003X,
> >> >> > etc...through
> >> >> > all rows.
>
> >> >> > The spreadsheet contains approximately 2300 rows, currently sorted
> >> >> > by
> >> >> > name.
> >> >> > I need to sort by Password in the above indicated order.
>
> >> >> > Anybody have any ideas how his might be done? Or if it's even
> >> >> > possible?
>
> >> >> > Thanks,
>
> >> >> > Mike- Hide quoted text -
>
> >> >> - Show quoted text -- Hide quoted text -
>
> >> - Show quoted text -- Hide quoted text -
>
> - Show quoted text -

Hi Guys,

Thanks for the advice.

Yes, Peo is correct, in that, just performing a simple sort by the password
column did not produce the results I was looking for.

I need the sort order results to be sequential by password order. In other
words, the first password issued was A001Z, the second was B002Y. I have
over 2000 passwords following this format. A simple sort gives me all
passwords starting with "A" first, then "B", etc. What I need is the
original issue order as above, A001Z, B002Y, etc.

I am a new user to Excel, but I am quickly discovering it's many advantages
and how they can make my job a lot easier. My first, and greatest, problem
right now is attempting to apply Excel's functionality without having a
solid background using the program. I have several (large) books, which I
am currently reading from cover to cover, and always search through them, as
well as these newsgroups and the internet to try and find an answer before I
post a question. I try to be as self-sufficient as possible.

The second problem, in this case, is that I inherited this password system,
which has been used for the last 15+ years, and, had I managed it from the
beginning, would have kept a copy by Password order.

So, again, thank you, and I will try Peo's sorting method and see what
results.

Respectfully,

Mike

"Pete_UK" <pashurst.RemoveThis@auditel.net> wrote in message
news:1186530993.125699.326360@19g2000hsx.googlegroups.com...
> Yes, I thought that myself to begin with, then I realised that he had
> posted into the newusers group, so I decided not to read too much into
> it.
>
> Pete
>
> On Aug 8, 12:49 am, "Peo Sjoblom" <terr....RemoveThis@mvps.org> wrote:
>> Yes they will, somehow I assumed the OP wouldn't have asked this unless
>> there was more to it than meets the eye
>>
>> --
>> Regards,
>>
>> Peo Sjoblom
>>
>> "Pete_UK" <pashu....RemoveThis@auditel.net> wrote in message
>>
>> news:1186529613.146917.88950@q75g2000hsh.googlegroups.com...
>>
>>
>>
>> > Hi Peo,
>>
>> > don't you think that the password values (as quoted by the OP) will
>> > sort correctly, without needing helper columns?
>>
>> > Pete
>>
>> > On Aug 7, 11:44 pm, "Peo Sjoblom" <terr....RemoveThis@mvps.org> wrote:
>> >> You need 2 help columns, preferably in D and E
>>
>> >> assume you have headers, so in D2
>>
>> >> =LEFT(C2)
>>
>> >> in E2
>>
>> >> =MID(C2,2,3)
>>
>> >> copy down by double clicking the lower right corner of E2 after select
>> >> D2
>> >> and E2
>> >> then if you want to sort by password sort by the first help column and
>> >> secondly the
>> >> second help column. If needed create a help column for the last
>> >> character
>> >> in
>> >> the pw
>>
>> >> =RIGHT(C2,1)
>>
>> >> --
>> >> Regards,
>>
>> >> Peo Sjoblom
>>
>> >> "Michael Slater" <mslater....RemoveThis@comcast.net> wrote in message
>>
>> >>news:wuadnQRvULhzeCXbnZ2dnUVZ_qKgnZ2d@comcast.com...
>>
>> >> >I have a spreadsheet that contains 3 columns:
>>
>> >> > Col A = Names
>> >> > Col B = Dates of Birth
>> >> > Col C = An Assigned Password
>>
>> >> > The passwords are formatted as follows: A001Z, B002Y, C003X,
>> >> > etc...through
>> >> > all rows.
>>
>> >> > The spreadsheet contains approximately 2300 rows, currently sorted
>> >> > by
>> >> > name.
>> >> > I need to sort by Password in the above indicated order.
>>
>> >> > Anybody have any ideas how his might be done? Or if it's even
>> >> > possible?
>>
>> >> > Thanks,
>>
>> >> > Mike- Hide quoted text -
>>
>> >> - Show quoted text -- Hide quoted text -
>>
>> - Show quoted text -
>
>