PLEASE HELP--Sorting one column to match entries in another
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: PLEASE HELP--Sorting one column to match entries in another

  1. #1
    Board Regular wilkisa's Avatar
    Join Date
    Apr 2002
    Location
    Decatur IL, USA
    Posts
    632
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    The sheet has 11 columns, A to K. Col. A-E are in the correct order; Col. G-K needs to be sorted so that the information in Col G matches the information in Col. A. Col. F is blank.

    I would be happy to send an example if someone could give me a hand. I tried to put an example in an early message but got no help so I figured the example didn't make sense.





  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    134
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Highlight columns A through K. Then Select Data from the menu. Then Sort... Then Select Sort By Column G. Then hit OK.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com