| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Cells will not calculate
I am using the replace feature to modify a rather long formula. I have to
modify it in each column, abour 30 cells per column. Anyway I am replacing $D with $E = the replace feature works perfectly but after the change the cell does not calculate and return the data... HELP. It is far to tedious to make the chabge manually. =IF(ISNA(MATCH("N12",Schedule!$D$49:$D$102,0)),"", INDEX(Schedule!$B$49:$B$102,MATCH("N12",Schedule!$ D$49:$D$102,FALSE))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Order of selecting unprotected cells | Excel Discussion (Misc queries) | |||
| Calculate matching cells | Excel Worksheet Functions | |||
| HOW NOT TO CALCULATE CELLS IF ONE CONTAINS "0" | Excel Worksheet Functions | |||
| calculate percentage of two cells | Excel Worksheet Functions | |||
| calculate the sum of cells where values are between 6 and 10 in e. | Excel Worksheet Functions | |||
Threaded Mode
