Adding a count

[karo3440]

I need some helt creating a count in Excel. In the attached file I would like to add a column showing the number of times an customer order has been partly delived. Order number 2070002191 has been split into 2 deliveries - the first delivery on 2. February and the secound delivery on 3. February. What I would like to calculate automatically is a column showing the number of deliveries for a given order number and what delivery was the first. I have manually keyed in the wished result in column F (red column).

Thanks a lot in advance for your help!

[MickG]

Can you attach your file in ".xls" format.

[karo3440]

Hope this version is ok

[MickG]

Try this:-
Results in column "F"

Please Login or Register  to view this content.

Regards Mick

[karo3440]

Dear Mick.

Thanks a lot - it is working perfectly! Perhaps you can help me once again....

I had to add some additional information to the file so the layout looks different now. The problem is almost the same:
I would like to add an automatic count (f.ex. in column AN) so for each customer order (col. D) and each delivery date (col. U). For order number 2070002117 there are 2 delivery dates and I would like "1" to be shown for 13.01.2011 and "2" to be shown for 24.01.2011.....

Thanks a lot in advance.

[MickG]

Try this:-

Please Login or Register  to view this content.

Regards Mick

[karo3440]

You're the best! Thanks a lot!