+ Reply to Thread
Results 1 to 15 of 15

Complicated Alphabatizing Problem - Please Help!

  1. #1
    Registered User
    Join Date
    07-02-2012
    Location
    Indiana, USA
    MS-Off Ver
    Excel 2007
    Posts
    25

    Complicated Alphabatizing Problem - Please Help!

    I need to alphabatize a excel spreadsheet by first name and last name. However, I also need the data in the other columns coresponding with the persons row to change with it as well. For example I know how to make the last and first name become alphabitized in this senerio, however it doesn't change the other two columns:

    Smith, Jane $92 Filed
    Smith, Kayla $07 Unfiled
    Smith, Alle $12 Unfiled

    So if i alphabetized this it would be:

    Smith, Alle $92 Filed
    Smith, Kayla $07 Unfiled
    Smith, Jane $12 Unfiled

    and not how I want it to be:

    Smith, Alle $12 Unfiled
    Smith, Kayla $07 Unfiled
    Smith, Jane $92 Filed

    Make sense? I have 300 pages to alphabatize so please give me the easiest way! Thanks!
    Last edited by privatesinn; 07-02-2012 at 03:43 PM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Complicated Alphabatizing Problem - Please Help!

    You get better help if you post an Excel-example of your workbook, without confidential information.

    Make sure the workbook demonstrates your desired results if possible, or just highlight the cells you're trying to fix.

    Use BEFORE/AFTER sheets if that helps make it clearer.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    06-14-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Complicated Alphabatizing Problem - Please Help!

    right select the names you want to sort out then on the toolsbar ( home) then choose sort and filter then sort A to Z.

    A pop in will ask you if you want to extand it. Select it and everything will be in order.

  4. #4
    Registered User
    Join Date
    07-02-2012
    Location
    Indiana, USA
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Complicated Alphabatizing Problem - Please Help!

    Hmm, just tried this and didn't get any pop ins. It just sorted it the incorrect way

  5. #5
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,067

    Re: Complicated Alphabatizing Problem - Please Help!

    Make sure that when you sort the data your selection contains the columns with the 'other' data too. Then sort on first name.
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  6. #6
    Registered User
    Join Date
    06-14-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Complicated Alphabatizing Problem - Please Help!

    i ve just done it. it works but yeah make sure you select everything you want to sort out.

  7. #7
    Registered User
    Join Date
    07-02-2012
    Location
    Indiana, USA
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Complicated Alphabatizing Problem - Please Help!

    Quote Originally Posted by carole91 View Post
    right select the names you want to sort out then on the toolsbar ( home) then choose sort and filter then sort A to Z.

    A pop in will ask you if you want to extand it. Select it and everything will be in order.
    Got the pop in, however, now it says the cells that are merged need to be identacally sized

  8. #8
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,067

    Re: Complicated Alphabatizing Problem - Please Help!

    Merged cells will always cause problems. If they are merged across columns for 'cosmetic' appeal, unmerge and use 'center across selection' under Cell format.

  9. #9
    Registered User
    Join Date
    06-14-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Complicated Alphabatizing Problem - Please Help!

    Right i dont know why you excel is saying that. I m using excel 2010 and the size of my cells arent the same at all and i dont have any problem or any other text poping in

  10. #10
    Registered User
    Join Date
    07-02-2012
    Location
    Indiana, USA
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Complicated Alphabatizing Problem - Please Help!

    Ok so i unmerged everything and centered across selection for the same look. Now when I select the column and press sort, i dont even get the pop in andymore it just automatically sorts it the incorrect way... I feel like I am getting closer but not quite there yet. Thanks for the ongoing support everyone!

  11. #11
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,067

    Re: Complicated Alphabatizing Problem - Please Help!

    Please refer to Post # 5. You need to ensure that you select all columns including the ones that contain the 'other' data

  12. #12
    Registered User
    Join Date
    07-02-2012
    Location
    Indiana, USA
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Complicated Alphabatizing Problem - Please Help!

    Actually I think I solved it! Give me a minute to look over the document!

  13. #13
    Registered User
    Join Date
    06-14-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Complicated Alphabatizing Problem - Please Help!

    Did you manage to solve your problem ?

  14. #14
    Registered User
    Join Date
    07-02-2012
    Location
    Indiana, USA
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Complicated Alphabatizing Problem - Please Help!

    I solved it! After un merging everything, centering across the rows, and then selecting all the data and sorting A-Z I was able to solve my problem! Thanks for the help everyone!!!

  15. #15
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,067

    Re: Complicated Alphabatizing Problem - Please Help!

    Enjoy the forum. It always easy once you know the solution Please mark the thread as solved

    To mark your thread solved do the following:
    - Go to the first post
    - Click edit
    - Click Advance
    - Just below the word "Title:" you will see a dropdown with the word No prefix.
    - Change to Solve
    - Click Save

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1