+ Reply to Thread + Post New Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 21 of 21

Reversing the Order of Words in Columns

  1. #16
    Forum Guru newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,293

    Re: Reversing the Order of Words in Columns

    Why not just reverse the names and from the Data tab click on the Filter button to add filters to each column then sort in order.
    Name List Capture.JPG
    Last edited by newdoverman; 01-12-2017 at 02:08 PM.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  2. #17
    Registered User
    Join Date
    01-04-2017
    Location
    Sheffield
    MS-Off Ver
    Microsoft Excel Starter 2010, Microsoft Office version 14.0
    Posts
    10

    Re: Reversing the Order of Words in Columns

    Quote Originally Posted by newdoverman View Post
    Why not just reverse the names and from the Data tab click on the Filter button to add filters to each column then sort in order.
    Attachment 496879
    I wasn't aware that Excel Starter 2010 had a Data tab. According to the literature that I've read, it doesn't have one, although that could be wrong.

    Thanks again for your reply. I fully understand where I was going wrong in terms of not filling the formulae down the columns to accommodate all the data. So I've cracked that part.

    It seems like all my problems have now been cracked apart from being able to arrange the reversed names (including duplicates) into alphabetical order.

    Is there a formula you could suggest that would do that for me?

  3. #18
    Registered User
    Join Date
    01-04-2017
    Location
    Sheffield
    MS-Off Ver
    Microsoft Excel Starter 2010, Microsoft Office version 14.0
    Posts
    10

    Re: Reversing the Order of Words in Columns

    Quote Originally Posted by newdoverman View Post
    Why not just reverse the names and from the Data tab click on the Filter button to add filters to each column then sort in order.
    Attachment 496879
    I wasn't aware that Excel Starter 2010 had a Data tab. According to the literature that I've read, it doesn't have one, although that could be wrong.

    Thanks again for your reply. I fully understand where I was going wrong in terms of not filling the formulae down the columns to accommodate all the data. So I've cracked that part.

    It seems like all my problems have now been cracked apart from being able to arrange the reversed names (including duplicates) into alphabetical order.

    Is there a formula you could suggest that would do that for me?

    Regards,

    Paul.

  4. #19
    Forum Guru newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,293

    Re: Reversing the Order of Words in Columns

    Assuming that all your data is across the worksheet like in the examples it would be far more efficient to select all the data including the original list, Click on the Data Tab, Click on the Filter Button to add the filters to the column headers. Click on the header for the Reversed names and sort into order. All the data will be sorted into order. The formulae should still work producing the correct results. You really don't want to sort 20000 records via formula. It would take a long time.

    If you want to sort via formula here is a setup that will go from the original data through to an alphabetic listing including duplicate names. You will have to fill the formulae down to the end of the data or it will not work. I have filled only a few rows which are in yellow in the file.
    Attached Files Attached Files

  5. #20
    Registered User
    Join Date
    01-04-2017
    Location
    Sheffield
    MS-Off Ver
    Microsoft Excel Starter 2010, Microsoft Office version 14.0
    Posts
    10

    Re: Reversing the Order of Words in Columns

    Thank you so much for doing that for me newdoverman. My list of reversed names is now in alphabetical order including duplicates. I'm a very happy man!

    Thanks also for all your help these past few days - you have been so generous. It really means a lot.

    All the best.

    Paul.

  6. #21
    Forum Guru newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,293

    Re: Reversing the Order of Words in Columns

    Thank you for giving feedback and the rep.
    Good luck.

+ Reply to Thread + Post New Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

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

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