Quote:
Originally Posted by Prototype
If you can, have the A#'s in Column A, and the Open/Close in Column B.
In column C, insert this formula: =IF(A3=A2, 0, IF(B2="Open", 1, 0)), then go fill down to the cells below that you need a result.
Then do a =Sum(C2:C9) in C10.
Result should be 4.
PM me if you need me to email it to you.
|
So that will count the first occurrence of a value but none of the following if they are the same as long as the same values are one after the other?