| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 23439 | 2002-08-16 06:47:00 | Lists in MS Excel | minchy (1524) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 71595 | 2002-08-16 06:47:00 | In a list of say 30 people which is numbered consecutively in one column. Is it possible to remove one name, say number 10, and then renumber the rest? | minchy (1524) | ||
| 71596 | 2002-08-16 07:05:00 | Yes | godfather (25) | ||
| 71597 | 2002-08-16 08:19:00 | If you get your 'numbers' by using a formula such as =ROW()+X (where X is an offset to get the number series in the range you want, you can delete rows and have the numbers adjust accordingly. | wuppo (41) | ||
| 71598 | 2002-08-16 13:10:00 | ... and the sore is wuppo 1 godfather 0 |
Russell D (18) | ||
| 71599 | 2002-08-18 00:47:00 | Thank you wuppo - F1 proves its usefulness again. Minchy | minchy (1524) | ||
| 71600 | 2002-08-18 00:48:00 | Presume the computer deleted the rest of your message eh? I assumed the innate intelligence of this forum and phrased my question accordingly. | minchy (1524) | ||
| 71601 | 2002-08-18 01:56:00 | Sorry, I had just started the reply and an urgent matter arose, so had to attend to it. Forum didnt delete it, it was never sent. But, you have to agree, I answered your question...... |
godfather (25) | ||
| 71602 | 2002-08-18 02:20:00 | > Sorry, I had just started the reply and an urgent > matter arose, so had to attend to it. Rats. |
Susan B (19) | ||
| 71603 | 2002-08-18 03:26:00 | > Rats. Probably was, they have stopped taking the poison now, so hopefully all are RIP. Actually I thought I had quickly hit "cancel" but must have got "post" |
godfather (25) | ||
| 1 | |||||