Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
renumber automatically
I have a numbered waiting list with 500+ members. When someone in the middle
decides to cancel, I would like them to be renumbered automatically. Is this possible? It isn't diffiecult to clear the numbered column and then use autofill, but I want something more user friendly for my co-workers. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
renumber automatically
In A1 enter:
=ROW() and copy down this make a column of numbers. If you delete a row somewhere in the middle, the column will automatically re-number. -- Gary''s Student - gsnu200782 "JICDB" wrote: I have a numbered waiting list with 500+ members. When someone in the middle decides to cancel, I would like them to be renumbered automatically. Is this possible? It isn't diffiecult to clear the numbered column and then use autofill, but I want something more user friendly for my co-workers. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
renumber automatically
One way:
A1: 1 A2: =A1 + 1 copy down In article , JICDB wrote: I have a numbered waiting list with 500+ members. When someone in the middle decides to cancel, I would like them to be renumbered automatically. Is this possible? It isn't diffiecult to clear the numbered column and then use autofill, but I want something more user friendly for my co-workers. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
renumber automatically
JE McGimpsey's suggested didn't exactly work because when I deleted a waiting
list member in the middle it produced a #REF error, which I could easily correct but not so hands off. Gary's student's suggestion didn't exactly work because there were header rows and a title row so the first person on the waiting list #1, was on row 3. So I combined the two and made the formula =ROW()-2, and got the numbering system perfectly! Thanks guys!! "JICDB" wrote: I have a numbered waiting list with 500+ members. When someone in the middle decides to cancel, I would like them to be renumbered automatically. Is this possible? It isn't diffiecult to clear the numbered column and then use autofill, but I want something more user friendly for my co-workers. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can you automatically add symbols | Excel Discussion (Misc queries) | |||
St automatically changes to So | Excel Discussion (Misc queries) | |||
how do you renumber column in your excel table | Excel Discussion (Misc queries) | |||
how do set a number so that it automatically changes | Excel Worksheet Functions | |||
sort automatically | Excel Worksheet Functions |