lorikgator
New Member
- Joined
- Aug 26, 2014
- Messages
- 25
This answer may exist and I just don't know the right combo of Google search terms to find it because I've tried everything!
I have a "to do" list and I want to add a unique index number for each new entry BUT I'm going to be sorting the list for due dates and priorities. How can I automatically always increment to the largest number when I enter a new row? I know ROW() would get me the largest number, but then I'd have to also copy-> paste value every time. If that's the best/easiest way, so be it, but I figure there must be another option...
Excel 2007, Windows 7
Example:
<tbody>
</tbody>
I want to use a formula or maybe even a macro to always give the next highest number in the existing sequence, even though they're not sorted in their column.
Any ideas welcome!
Lorikgator
I have a "to do" list and I want to add a unique index number for each new entry BUT I'm going to be sorting the list for due dates and priorities. How can I automatically always increment to the largest number when I enter a new row? I know ROW() would get me the largest number, but then I'd have to also copy-> paste value every time. If that's the best/easiest way, so be it, but I figure there must be another option...
Excel 2007, Windows 7
Example:
Index | Task | Priority | Due Date | Status |
1003 | Manager report | 1 - High | 10/1/2014 | 2 - In progress |
1001 | Create presentation | 1 - High | 10/5/2014 | 1 - Not started |
1004 | Time sheet | 2 - Medium | 9/30/2014 | 2 - In progress |
1002 | Worksheet update | 2 - Medium | 9/25/2014 | 3 - On hold |
1005 | Check e-mail | 3 - Low | 9/10/2014 | 2 - In progress |
(1006) | (new row) |
<tbody>
</tbody>
I want to use a formula or maybe even a macro to always give the next highest number in the existing sequence, even though they're not sorted in their column.
Any ideas welcome!
Lorikgator