| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate column in sequential order by number of records
Hi all. I think I've seen this before. Let's say I have a spreadsheet that has 200 records. there are various fields associated with each record. I would like to add another colum that will populate to the number of records,this case 200, in a sequential order. I would like to do this without typing in each number. Thx. -- araki ------------------------------------------------------------------------ araki's Profile: http://www.excelforum.com/member.php...o&userid=15334 View this thread: http://www.excelforum.com/showthread...hreadid=537298 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Populate column in sequential order by number of records
put 1 in the first cell, hold CTRL and drag down to last record. This number
1,2,3 ..... "araki" wrote: Hi all. I think I've seen this before. Let's say I have a spreadsheet that has 200 records. there are various fields associated with each record. I would like to add another colum that will populate to the number of records,this case 200, in a sequential order. I would like to do this without typing in each number. Thx. -- araki ------------------------------------------------------------------------ araki's Profile: http://www.excelforum.com/member.php...o&userid=15334 View this thread: http://www.excelforum.com/showthread...hreadid=537298 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Generate Auto Order Number | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Deleting specific records | Excel Discussion (Misc queries) | |||
Linear Mode
