| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill a column with sequential numbers
Hi all.
I know i've seen this before. Let's say i have a worksheet with 200 records and various fields. I want to add another field labeled "Lot" and want to populate it seqentially from 1 to 200. Now, I could do this manually and add them in 1 by 1, but I could swear I've seent a trick that will do it from 1 to 200. Any tip/idea would be appreciated. Thx, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Consecutive Numbers down a column not to Exceed 49 | Excel Worksheet Functions | |||
| match and count words | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Threaded Mode
