M
MrBill
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.
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.