Consulting

Results 1 to 3 of 3

Thread: Linking cells, sorting by values in column

  1. #1
    VBAX Regular
    Joined
    Jun 2012
    Posts
    13
    Location

    Linking cells, sorting by values in column

    Hi,

    I want to have cells linked, so when I do a numeric sort on a column those numerical values stay associated with their partnered cell.

    For example

    C1 C2
    jeri 3
    matt 1
    una 2
    harrison 4

    How can I sort column 2 numerically and have C1's result be matt, una,jeri,harrison?

    Thanks!

  2. #2
    VBAX Regular GreenDR's Avatar
    Joined
    Oct 2012
    Location
    India
    Posts
    25
    Location
    select data
    right click-> sort -> custom sort
    Sort By: C2
    Sort On: Values
    Order: Smallest to Largest
    GreenDR

  3. #3
    VBAX Regular
    Joined
    Jun 2012
    Posts
    13
    Location
    Thanks

Posting Permissions

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