| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I enter a formula so that it follows the sequence of line#
I have a spread sheet with some 15000 lines in it. One of the formulas in my
sheet has been chaged from top to bottom. It is caculating for the incorrect rows. I need the formula to be changed back so the formula reflects the line # it is on. How can i change this without having to do each line manually? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I enter a formula so that it follows the sequence of line#
Can you give us an example of your formula? (In most cases if you are doing
a calculation on a row by row basis you can enter the correct formula in the 1st cell and then copy it down as far as you need and it will automatically increment the cell references in the formulas for you.) "losthelp" wrote: I have a spread sheet with some 15000 lines in it. One of the formulas in my sheet has been chaged from top to bottom. It is caculating for the incorrect rows. I need the formula to be changed back so the formula reflects the line # it is on. How can i change this without having to do each line manually? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use a formula to create a new line of text in a cell? | Excel Worksheet Functions | |||
| How do I enter a formula that will delete a line when a cell = 0? | Excel Worksheet Functions | |||
| Continue formula to LINE 1000 without showing FALSE | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Hybrid Mode
