Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for serial number
sir,
In my range of data, the first column is of serial number where in I put 1 in A1 and use the formula A1+1 in A2 and copying the same downwards. It works perfectly unless I delete a row the range. When I delete a row #REF! will appear in the remaining rows. Is any way to avoid this, i mean , when I delete a row the formula should catch the number in the above row +1 in the next. please help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for serial number
Try:-
In A1 =ROW(A1) Drag down and delete a row and see what happens. Mike "shaji" wrote: sir, In my range of data, the first column is of serial number where in I put 1 in A1 and use the formula A1+1 in A2 and copying the same downwards. It works perfectly unless I delete a row the range. When I delete a row #REF! will appear in the remaining rows. Is any way to avoid this, i mean , when I delete a row the formula should catch the number in the above row +1 in the next. please help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for serial number
You could just use:
=ROW() to generate your sequence. This would automatically adjust if you delete a row. Hope this helps, Pete On Jun 25, 10:41 am, shaji wrote: sir, In my range of data, the first column is of serial number where in I put 1 in A1 and use the formula A1+1 in A2 and copying the same downwards. It works perfectly unless I delete a row the range. When I delete a row #REF! will appear in the remaining rows. Is any way to avoid this, i mean , when I delete a row the formula should catch the number in the above row +1 in the next. please help |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for serial number
It works only when the serial number is same as of the row number.
is there any other way "Pete_UK" wrote: You could just use: =ROW() to generate your sequence. This would automatically adjust if you delete a row. Hope this helps, Pete On Jun 25, 10:41 am, shaji wrote: sir, In my range of data, the first column is of serial number where in I put 1 in A1 and use the formula A1+1 in A2 and copying the same downwards. It works perfectly unless I delete a row the range. When I delete a row #REF! will appear in the remaining rows. Is any way to avoid this, i mean , when I delete a row the formula should catch the number in the above row +1 in the next. please help |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for serial number
On Mon, 25 Jun 2007 02:41:03 -0700, shaji
wrote: sir, In my range of data, the first column is of serial number where in I put 1 in A1 and use the formula A1+1 in A2 and copying the same downwards. It works perfectly unless I delete a row the range. When I delete a row #REF! will appear in the remaining rows. Is any way to avoid this, i mean , when I delete a row the formula should catch the number in the above row +1 in the next. please help Change your formula A2: =$A$1+ROWS($1:1) --ron |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for serial number
Thanks, it is working perfectly.
"Ron Rosenfeld" wrote: On Mon, 25 Jun 2007 02:41:03 -0700, shaji wrote: sir, In my range of data, the first column is of serial number where in I put 1 in A1 and use the formula A1+1 in A2 and copying the same downwards. It works perfectly unless I delete a row the range. When I delete a row #REF! will appear in the remaining rows. Is any way to avoid this, i mean , when I delete a row the formula should catch the number in the above row +1 in the next. please help Change your formula A2: =$A$1+ROWS($1:1) --ron |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for serial number
On Mon, 25 Jun 2007 04:51:00 -0700, shaji
wrote: Thanks, it is working perfectly. You're welcome. Glad to help. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
serial number decode | Excel Worksheet Functions | |||
Serial Number List | Excel Discussion (Misc queries) | |||
serial number cell | Excel Worksheet Functions | |||
Serial number allocation - Array formula | Excel Worksheet Functions | |||
generate serial number | Excel Worksheet Functions |