Try this:
1. Copy this into A1:
=COUNT(B:B)
2. Copy this into B2 and fill down the column as far as
you think you'll need it:
=IF(A2="","",IF(A2,MAX($B$1:B1)+1,""))
3. Star filling in col. B with TRUE/FALSE
HTH
Jason
Atlanta, GA
-----Original Message-----
How can I increment a counter in a worksheet cell from
the value entered in
other cellsl? For instance if the value in cell A2 =
true I want to replace
the value in B2 with the value in A1(the counter), then
increment the value
in A1 by 1. The worksheet might look like this:
A B
1 4
2 TRUE 1
3 FALSE
4 TRUE 2
5 TRUE 3
6
7
.
|