Logical operators not working with text???
Slinky <slinky_ISAT_newsguy_DOT-com wrote...
....
in the A row are below:
* * * * A * * * B
1 - * * *TTTT * *0
2 - * * TTUU * * Formula Below
3 - * * TTUU
4 - * * VVVV
5 - * * WWW
6 - * * WWW
In the B row I set B1 to zero and then type the following in cell 2:
=IF(A2=A1,B1+0,B1+1)
....
A and B are COLUMNS, not rows.
. . . the
above should put out the following in the B row - 0, 1, 1, 2, 3, 3. It
works on the first statement and everything else stays the same - 0,
1, 1, 1, 1, 1, 1, 1..
Press the [F9] key. The situation you describe is very likely due to
manual recalculation.
|