Excel Formula Help

[Purity14]

Hey Guys, I require some excel assistance, as my head is wrecked.

I have a spreadsheet like this:

 

Dave 1

Dave 1

Dave 1

John 1

John 1

Havard 1

Havard 1

Havard 1

 

And I would like a formula in the third column to do this:

 

Dave 1 1

Dave 1 2

Dave 1 3

John 1 1

John 1 2

Havard 1 1

Havard 1 2

Havard 1 3

 

I have had close results, but no cigar - am I missing something obvious?

How can i reset a running total based on conditions?

[johnny g]

Assuming you've got Names in A, Values in B and you;re starting on Row 1.

Cell C1 =B1

Cell C2 =IF(A2=A1,B2+C1,B2)

 

Then drag that down

[Scott]

You would need to run a macro to do that bud, it requires variables.

 

Edit: Unless of course you are ok with the names having to be in order in which case the above solution is perfect

[Purity14]

Thanks Johnny, god that was simple, i was overcomplicating it.