+ Reply to Thread
Results 1 to 2 of 2

Sorting a Column containing names

  1. #1
    Registered User
    Join Date
    09-23-2013
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    28

    Sorting a Column containing names

    Sorting a Column containing names and want all the rows with respect to that name to be sorted accordingly
    for example
    satpal 10 20 30
    Jorge 20 40 60

    then after sorting it should be
    Jorge 20 40 60
    satpal 10 20 30

    any help is appreciated.

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Sorting a Column containing names

    If your data is organized similar to sort1.png and sorting range only includes names the values will not be sorted. To include the values sorting range must be set up as shown in sort2.png

    Alf
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel Names in column to text files names to folder
    By excelaron in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-17-2013, 07:22 PM
  2. Replies: 5
    Last Post: 01-13-2012, 03:20 PM
  3. Sorting Column Containing Comma Delimited Names
    By Terrance in forum Excel General
    Replies: 1
    Last Post: 10-25-2007, 07:17 AM
  4. Sorting 2 names in one column
    By Hides_Twins in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-04-2006, 11:10 AM
  5. [SOLVED] sorting names alphabetically when names may start with numbers
    By John Smith in forum Excel General
    Replies: 3
    Last Post: 05-11-2005, 04:06 PM

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