Counting Repeat Occurances Using a Helper Column

Sheet 3 data is not properly pasted into the sheet. But look at sheet 1. Is your expected result correct? Shouldn't it be: 1, 1, 2, 1 ??

I have attached a corrected version.

Also yes, it should be 1, 2, 1... because its re'elections. so to be counted as a re-election you need to already be in power. so basically re-elections only count when Sheet3!A4=Sheet3!A3 and when A5=A4. If A5 does not =A4 then someone new is in power and it is not a re-election.

Thanks for helping me, I really appreciate it.

edit:

Republican
Republican - here
Democrate

This example would be 1 republican re-election.

Republican
Democrat
Republican
Democrat

This example would have 0 re-elections.

This one is causing a bit of brain-pain...

I have come up with a highly ineffient helper table.. the main problem is how each country would require its own helper table. If there are 6 reelections, I need 6 helpers in this table too.

Not sure how to adjust it or how to use the helper to help.. sorry im really new to excel.

Put the following formula in F3 on Sheet 3 then drag the fill handle down to F22: =IF(OR(E2="helper",E3=1),"",SUM(E$2:E2)-SUM(F$2:F2))
Also populate column B on sheet2 using:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.