1. Welcome! Please take a few seconds to create your free account to post threads, make some friends, remove a few ads while surfing and much more. ClutchFans has been bringing fans together to talk Houston Sports since 1996. Join us!

  2. ROCKETS GAMEDAY
    Will facing a tanking team help? Rockets in Memphis Friday night to face the Grizzlies. Come join Ben & Dave for live reaction in postgame!

    LIVE! ClutchFans on YouTube
Welcome ClutchFans Live

Stupid Excel Question

Discussion in 'BBS Hangout' started by Rocketman95, Jun 12, 2008.

  1. Rocketman95

    Rocketman95 Hangout Boy

    Joined:
    Feb 15, 1999
    Messages:
    48,984
    Likes Received:
    1,446
    But I need it in a hurry.

    I have a column that is full of random six-digit numbers. I want to order it from the third row until the end from 1-whatever. How do I do that?
     
    #1 Rocketman95, Jun 12, 2008
  2. francis 4 prez

    francis 4 prez Member

    Joined:
    Aug 15, 2001
    Messages:
    22,025
    Likes Received:
    4,552
    do you just mean sort it in ascending order? just highlight the cells and either click the sort button (the one with A and Z and a down arrow) or go to Data and Sort.

    or maybe i misunderstood the question.
     
    #2 francis 4 prez, Jun 12, 2008
  3. codell

    codell Member

    Joined:
    Aug 26, 2002
    Messages:
    19,312
    Likes Received:
    716
    There are no stupid excel questions. Only stupid excel answers.

    :)
     
    #3 codell, Jun 12, 2008
  4. Rocketman95

    Rocketman95 Hangout Boy

    Joined:
    Feb 15, 1999
    Messages:
    48,984
    Likes Received:
    1,446
    Right now it's like this:

    376281
    482901
    874633
    984762

    I want to replace that with:

    1
    2
    3
    4

    If there weren't over 2600 rows, I'd just do it manually. :)
     
    #4 Rocketman95, Jun 12, 2008
  5. A_3PO

    A_3PO Member

    Joined:
    Apr 29, 2006
    Messages:
    49,304
    Likes Received:
    16,105
    In the column, select only the cells you want to sort. Then do, data, sort, ascending order.
     
    #5 A_3PO, Jun 12, 2008
  6. wizkid83

    wizkid83 Member

    Joined:
    May 20, 2002
    Messages:
    6,348
    Likes Received:
    850

    Highlight, then go to Data->Sort->choose ascending in the popup.
     
    #6 wizkid83, Jun 12, 2008
  7. thelasik

    thelasik Contributing Member

    Joined:
    May 9, 2005
    Messages:
    3,347
    Likes Received:
    72
    You can edit the first three cells or so:

    1
    2
    3


    Highlight those three cells from top to bottom then double click on the square on the bottom right of the selection.
     
    #7 thelasik, Jun 12, 2008
  8. Rocketman95

    Rocketman95 Hangout Boy

    Joined:
    Feb 15, 1999
    Messages:
    48,984
    Likes Received:
    1,446
    Not sure I could have come up with a more appropriate thread title.

    Thanks guys!
     
    #8 Rocketman95, Jun 12, 2008
(You must log in or sign up to post here.)

Share This Page