If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Workbook LOCKED - Up
091116 Workbook LOCKED - Up
hi, I have ran into a strange formula problem. a line that works follows, the next example somehow got inserted into my sheet. =IF(OR(COUNTIF(EO563:EP563,{"",0,"n/a"})),0,1) This example has 3 0's, had to find this problem the hard way (deleting all cols/rows around it till found). SYMPTOMS: (HOW DO I DELETE ROWS, thanks) - CAN ADD DATA & SAVE, BUT NOT CALCULATE SHEET. sheet will close as "excel has experienced an error & must close". - CAN NOT DELETE ROWS, same consequence. - "CAN" copy above & below 2 problems rows, to a new sheet, but columns are not at desired width (too many columns). =IF(OR(COUNTIF(EO563:EP563,{"0","0","0"})),0,1) NOTE: could not reproduce error as such, must be some kind of error hook to these 2 rows, that have this formula. you can ask for more details, but have no idea what else would pertain. |
Thread Tools | |
Display Modes | |
|
|