Delivery Drop No.?

[Northerner]

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.

 

[Mudface]

Incidentally, does anyone know why I'm getting blanks with the following formula, despite the function returning the correct answer when you go into the Insert Function dialog?

Book2
	A	B	C	D
1	1	1234	Fred
2		1234	Fred
3		1234	Fred
4		5678	Barney
5		9101	Wilma
Sheet1

 

[Aladin Akyurek]

The Mudface question...

A2:

=IF(B2=B1,"",MAX($A$1:A1)+1)

 

[Mudface]

The Mudface question...

A2:

=IF(B2=B1,"",MAX($A$1:A1)+1)

That's the one, I got a circular reference, ignored it and forgot to correct it later on . Thanks, Aladin.

 

[Northerner]

Thanks for the interest guys,
Mudface's end result is the closest, but I would prefere only one '1' against the first Fred.
I'd love to dump an example but unfortunatly at work we run a Thin Client system.
If we (sorry you ) can't resolve this afternoon, I'll use Colo's Utility from home this evening.
ary: but I have every confidence in you.

 

[Mudface]

Well, with Aladin's correction, this seems to work as you wanted:-

Book2
	A	B	C	D
1	1	1234	Fred
2		1234	Fred
3		1234	Fred
4	2	5678	Barney
5	3	9101	Wilma
Sheet1

 

[Aladin Akyurek]

Thanks for the interest guys,
Mudface's end result is the closest, but I would prefere only one '1' against the first Fred.
I'd love to dump an example but unfortunatly at work we run a Thin Client system.
If we (sorry you ) can't resolve this afternoon, I'll use Colo's Utility from home this evening.
ary: but I have every confidence in you.

Can 1234 be combined with different names, not just with Fred?

 

[Northerner]

The 1234 & Fred are just meant to represent a customer account number and name

 

[Aladin Akyurek]

The 1234 & Fred are just meant to represent a customer account number and name

Then Chris's (Mudface) formula as amended should work. Gee, you made me run, Northerner. The data must be sorted though.

 

[Northerner]

Mudface, Aladin and Fairwind, thanks for your input.
Yes Aladin, Mudface's was right, I'd dismissed it as the first drop number was not a formula but a static '1'. My program inserts new lines and copies formulie for each new 'delivery'. After you made me look at it again I realised I need only insert a blank line BEFORE my first delivery with a zero in it, then I could use Mudface's formula and have it copied each time it was required. (Well I know what I mean )

Thanks again to you all!!

And my next problem is..............................?