Northerner
Board Regular
- Joined
- Nov 13, 2002
- Messages
- 149
I am currently developing a route check sheet for our drivers. Can someone assist in counting the unique entries by account Number?
My sheet will show Account No. in Col G starting from G4.
I have found =IF(G4<>G3,COUNTA($G$3:G4)&".","") but this has the fault in that if I have 3 deliveries to an address, the next delivery drop count is incremented by 3 and not by 1.
1. 1234 Fred
....1234 Fred
....1234 Fred
4. 5678 Barney
5. 9101 Wilma
Any assistance or pointing in the right direction greatfully recieved.
My sheet will show Account No. in Col G starting from G4.
I have found =IF(G4<>G3,COUNTA($G$3:G4)&".","") but this has the fault in that if I have 3 deliveries to an address, the next delivery drop count is incremented by 3 and not by 1.
1. 1234 Fred
....1234 Fred
....1234 Fred
4. 5678 Barney
5. 9101 Wilma
Any assistance or pointing in the right direction greatfully recieved.