Results 1 to 5 of 5

Help in sorting

Threaded View

  1. #3
    Registered User
    Join Date
    08-15-2011
    Location
    chennai
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Help in sorting

    See there are 2 rows and 6 columns

    1st row has values : 4,232,808,4444,909,45

    2nd row has values : 39,4545,444,343,455,66

    now when i sort using the simple sort function it is displaying

    Frst row : 4,45,232,808,909 ,4444

    second row : 39,66,444,343,455,4545

    i.e,. it is just sorting the row..but the 39 present in the second row should come to the frst row after 4 for my requirement like

    Frst row : 4,39,45,66,232,343

    Second row :444,455,808,909,4444,4545

    i dnt need excel to differentiate the rows and columns...it should combine accordingly i.e., values from second row should be shifted to frst row if needed like 39 which is present in the second row should come to frst row bcos it is the next greater digit after 4.... I think there must be some simple way which i am unable to find
    Attached Files Attached Files

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1