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.
|
i think in the limited example shown above, this formula works fine - however i think if you had 3000 entries that were not in any type of order this formula may not yield the result the op is looking for.
to me a pivot table is the way to go - although they can be cumbersome.....my initial thought was to insert a blank column and then concatenate clolumn A & B and then do something off of that - but perhaps the PTable is easier.