Formula to Count sequentially adding 1 if previous two row/column criteria don't match

What im trying to accomplish is: Formula to count sequentially, adding 1 if previous two row/column criteria don't match, otherwise if a match, then repeat the same #.
I feel like I'm close to getting this to work, but I'm not fully understanding the function of it fully. I found something with a google search that got me in the general direction I need to go. Potentially could save me hours on these data spreadsheets for parent contact info, albeit I've already spent over an hour trying to get it to work properly for my scenario.

heres a sample of a formula I found: =IFERROR(VLOOKUP(IF(G13="",E13,G13),IF(G13="",$B$1:$E12,$B$1:$G12),IF(G13="",4,2),0),MAX($B$1:B12)+1)

Let me know what you think.

Try this,

B2

Please Login or Register  to view this content.

copied down.

You are welcome.
--------------------------------------
If that takes care of your original question, please click on "Thread Tools" from the menu link above and mark this thread as SOLVED.

Since I need to go further than 100 rows down,
Im changing: =IF(E2="","",IFERROR(INDEX($B$1:$B$100,(MATCH(E2&G2,$E$1:E1&$G$1:G1,0))),IF(ISNUMBER(B1),B1+1,1)))
to =IF(E2="","",IFERROR(INDEX($B$1:$B$500,(MATCH(E2&G2,$E$1:E1&$G$1:G1,0))),IF(ISNUMBER(B1),B1+1,1)))
and it breaks the thing when copied down...what gives? The matching quits working and it just continues to count sequentially.

Thanks!
That did it, it's weird though since the formula copied over doesnt exactly work, but when I copy the cell from your file into my file, and copy down it works fine.
The cell from your file has a preceding { symbol and ends with }, and when I go up in the formula bar to copy just the formula, those "{}" go away, and if i just copy the formula, it doesn't work like it does in your sheet.
Cant figure it out for the life of me. But your file works, and copying the cell works into my original spreadsheet.

Please, Committed with Ctrl+Shift+Enter after inputing formula.

I used Office 365. I forgot to check whether it is array foruma.

OH I got you now.
Thanks for that.

You are welcome.