Total by Name

B

Bob

Hello

I am new to using Excel and need help with totalling by name.

I am using VB6 to create a spreadsheet. I am sending 3 columns out
that I need to total the different names of the people submitting
orders.

The program will fille the sheet but I need to break the sheet where
the names stop. ( If this is making sense )

The sheet will start as this

Jeff 8258 01/10/2004
Jeff 9587 01/11/2004
Jeff 9956 01/12/2004
Bill 5478 01/10/2004
Bill 6458 01/11/2004
Bill 7520 01/12/2004
Bill 7912 01/13/2004
Bill 8109 01/14/2004

I would like it to end this way

Jeff 8258 01/10/2004
Jeff 9587 01/11/2004
Jeff 9956 01/12/2004

Total Jeff = 3

Bill 5478 01/10/2004
Bill 6458 01/11/2004
Bill 7520 01/12/2004
Bill 7912 01/13/2004
Bill 8109 01/14/2004

Total Bill = 5

Is this possible?
Thanks
Bob
 
B

Bob Phillips

Bob,

Use Data>Subtotals, break on column A, and use the Count function.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
B

Bob

Can this be done automaticlly?
I am exporting data to the worksheet from VB. Could I add the formula
somehow to the bar so it will automaticlly break and count if I don't
know the exact number of names?
 
D

Dave Peterson

Not with formulas, but you could record a macro and run that when you needed to
get the subtotals.

If you get stuck modifying your recorded macro, post back. I'm sure you'll get
lots of help.
 
Top