I have a spreadsheet with column headings and column A is rank order. The spreadsheet is always in order beginning with 1. How do I reorder the list by cutting and pasting rows and have column A automatically re-rank them? For example if I want to move the person that is ranked 100 up to number 6, how do I move their row of data but have their column A change to #6 and all those below 6 update to their new rank since someone was inserted above them? I can do it in 2-3 steps, but it needs to be done quickly and on the fly so I was wondering if anyone knew how to do it automatically?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Updating rank order while cutting and pasting rows
- Thread starter dll77
- Start date
Excel Facts
Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Thank you so much! I appreciate your help!Assuming you have headers in row 1, put the following formula in column A (in as many cells as your data range requires)
Excel Formula:=IF(B2<>"",ROW()-1,"")
Upvote
0
Similar threads
- Question
- Replies
- 11
- Views
- 353
- Replies
- 0
- Views
- 254
- Replies
- 4
- Views
- 299
- Replies
- 3
- Views
- 508
