Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Automatically move names when numbers are put in sheet

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Wisconsin
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have in one column names, and when registration takes place, I assign these names numbers, based on when these listed people register.

    It looks like this:
    Car # Scout
    Scout1
    Scout2
    Scout3
    Scout4
    Scout5

    Example:
    Scout5 registers first, and is assigned number 1, Scout4 registers next, and is assigned number 2, Scout2--number3,Scout1--number4, and Scout3--number5

    I would like to be able to place the numbers in front of the names, and then have these numbers automatically sort, taking the names assigned to them, to end up like this:

    Car # Scout
    1 Scout5
    2 Scout4
    3 Scout2
    4 Scout1
    5 Scout3

    What is the most convenient way to do this?
    Thanks,

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Put your scout names in column B when the time comes.

    In the cells of column a (starting row 2), put a 1 in cell A2. In cell A3 and then copied down, put:

    =if(isblank(b3),"",a2+1) It gives you an *autonumber* type of thing.
    ~Anne Troy

Some videos you may like

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
  •