Hi there,
What I need is a formula to count how many instances an order appears.
Fairly straightforward? Yes, but I need the formula to 'not' count duplicate order numbers or orders that have a negative qty next to them.
i.e
the same order number may appear 4 times in the raw data list, but I need that to be counted as just 1 order.
I have put the answers I am trying to find in the example to the right of the data.
Appreciate any help you may provide.
Bookmarks