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
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.
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.
thanks mrice it's helping
thanks, well you can see it that way, your trick is helpfull
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks