+ Reply to Thread
Results 1 to 5 of 5

Thread: reordering issue

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

    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 Guru mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2007/2010
    Posts
    3,004

    Re: reordering issue

    Paste

    =CELL("row",B2)-1

    into B2 and copy down.
    Martin

    Eighty Twenty Spreadsheet Automation http://homepage.ntlworld.com/martin.rice1/ for all your Excel customisation and consulting needs.

    If my solution has saved you time and/or money, please consider donating to Cancer Research UK.

  3. #3
    Valued Forum Contributor
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    MS Office Excel 2007
    Posts
    841

    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

    I rarely return to a problem once I've answered it so make sure you clearly define what the trouble is.

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

    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
    8

    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.2.0