First Occurrence Add Value To Total

[scrounge33]

I've a large and complex table. I need to add a value to the first occurrence in that table. Because of a rounding error that isn't going to be fixed anytime soon. I need to take the monthly amount, divide it by 4 weeks and add a penny to the first occurrence of a name. Something like:

Name	Monthly Amt	Weekly Deduct
Adams, Tyler	0	0
Brown, Jean	22.38	5.61
Brown, Jean	7.71	1.93
Castor, Billy	352.28	88.08
Castor, Billy	22.38	5.60
Castor, Billy	7.71	1.93
Diplo, Angie	672.56	168.15

<tbody>
</tbody>

On Adams, Tyler, we didn't add a penny because it is zero.
For Brown, Jean, a penny should be added to the first occurrence (thus 5.61 instead of 5.60) and not the second line for her.
Castor, Billy, has a penny added on the first line and not the other 2.
Diplo, Angie, had a penny added to her only line (as it is the first).

I hope I've explained that well enough for others to understand. Ready, set... GO!

 

[MARZIOTULLIO]

Hi


C2 =IF(AND(COUNTIF($A$2:A2,A2)=1,B2<>0),(B2/4+0.01),B2/4) Copy down

 

[scrounge33]

This works out great. However, today I noticed a change to the pattern that would throw Marziotullio's formula off. Company policy has changed the invoicing and I had the following come up:

Name	Monthly Amt	Weekly Deduct
Adams, Tyler	0	0
Brown, Jean	22.38	5.61
Brown, Jean	7.71	1.93
Castor, Billy	352.28	88.08
Castor, Billy	22.38	5.60
Castor, Billy	7.71	1.93
Diplo, Angie	672.56	168.15
Egles, Zach	0	0
Egles, Zach	126.33	126.33

<tbody>
</tbody>

The formula works great until Egles, Zach comes into the picture. The company now pays for his first deduction, but not the second, third, etc. How can I amend the formula to account for this?