Quote:
Originally Posted by Boblobla
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?
|
That formula will count the last value if all the values are together. It runs into the same problem as the solution I posted - if your data set looks like this:
A101 Open
A101 Open
A101 Closed
A201 Open
It'll miss A101, since the if statement will be completed when the PO# is closed.