Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatically number every other row
Hi, I need to be able to number every other row on my spread sheet. The
numbers must be 1,2,3 ect. but I need to skip a row inbetween each. Is this possible? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatically number every other row
Try something like this:
A1: Blank A2: =IF(ISNUMBER(OFFSET(A2,-1,0)),"",MAX($A$1:OFFSET(A2,-1,0))+1) copy that formula down as far as you need. It will number every other cell, beginning with 1 in A2. If you enter a number in A1, the numbering will resequence. Also, you can insert rows without throwing off the sequencing. Experiment with it, changing references to suit your situation. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "KGB" wrote: Hi, I need to be able to number every other row on my spread sheet. The numbers must be 1,2,3 ect. but I need to skip a row inbetween each. Is this possible? Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatically number every other row
Hi
One way Enter a 1 in A1, 2 in A3. Mark cells A1:A4. Grab the fill handle (the small black cross that appears as you hover over the bottom right corner of cell A4) and drag down as far as you need. -- Regards Roger Govier "KGB" wrote in message ... Hi, I need to be able to number every other row on my spread sheet. The numbers must be 1,2,3 ect. but I need to skip a row inbetween each. Is this possible? Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatically number every other row
Using column A. In A1 enter:
=IF(ISEVEN(ROW()),"",(ROW()+1)/2) and copy down -- Gary's Student "KGB" wrote: Hi, I need to be able to number every other row on my spread sheet. The numbers must be 1,2,3 ect. but I need to skip a row inbetween each. Is this possible? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to automatically number a new document(Invoice) when opening | Excel Discussion (Misc queries) | |||
How to automatically number a new document(Invoice) when opening | Excel Discussion (Misc queries) | |||
How to make Cells automatically become 'highlighted' when number . | Excel Worksheet Functions | |||
How to make Cells automatically become 'highlighted' when number . | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |