+ Reply to Thread
Results 1 to 5 of 5

reordering issue

  1. #1
    Registered User
    Join Date
    01-26-2012
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    10

    Question reordering issue

    Hi guys

    I am having in issue while am tryiing to reoder some tasks

    Tasks priority
    task 1 1
    task 2 2
    task 3 3
    task 4 4

    Let's say I want to reorder the priority of those tasks and need the task 3 to be on the top, So I would cut the whole row and insert it in front of task 1 but I want the priority column keep the same ranking which means from 1 to 4 in that order and not 3, 1,2,4.

    How could I automate that. I dont want to just renumber the priority column.
    Thanks

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: reordering issue

    Paste

    =CELL("row",B2)-1

    into B2 and copy down.
    Martin

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: reordering issue

    In that case the priority is NOT a priority and is just a sequential count of the rows with tasks.
    Use ROW() and copy it down the column.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  4. #4
    Registered User
    Join Date
    01-26-2012
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: reordering issue

    thanks mrice it's helping

  5. #5
    Registered User
    Join Date
    01-26-2012
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: reordering issue

    thanks, well you can see it that way, your trick is helpfull

+ Reply to Thread

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