VBA to assign consecutive value based on repeating data?

[ABLucas]

I have a sheet with tons of payment data that I need to assign an episode value. There are two columns in which there would be repeating data: Column "MRN" and Column "FDOS".

I want to assign a consecutive episode value of 0-5, to each row where the MRN & FDOS are repeating.

Example of how it looks when I manually enter the value in the Episode column. How can I make this less of a manual process?

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]MRN
[/TD]
[TD]Episode
[/TD]
[TD]FDOS
[/TD]
[/TR]
[TR]
[TD]123
[/TD]
[TD][/TD]
[TD]01/01/2017
[/TD]
[/TR]
[TR]
[TD]123
[/TD]
[TD][/TD]
[TD]01/01/2017
[/TD]
[/TR]
[TR]
[TD]123
[/TD]
[TD]1
[/TD]
[TD]01/02/2017
[/TD]
[/TR]
[TR]
[TD]123
[/TD]
[TD]1
[/TD]
[TD]01/02/2017
[/TD]
[/TR]
[TR]
[TD]456
[/TD]
[TD][/TD]
[TD]01/01/2017
[/TD]
[/TR]
[TR]
[TD]456
[/TD]
[TD][/TD]
[TD]01/01/2017
[/TD]
[/TR]
</tbody>[/TABLE]

 

[ABLucas]

I have a sheet with tons of payment data that I need to assign an episode value. There are two columns in which there would be repeating data: Column "MRN" and Column "FDOS".

I want to assign a consecutive episode value of 0-5, to each row where the MRN & FDOS are repeating.

Example of how it looks when I manually enter the value in the Episode column. How can I make this less of a manual process?

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]MRN
[/TD]
[TD]Episode
[/TD]
[TD]FDOS
[/TD]
[/TR]
[TR]
[TD]123
[/TD]
[TD]0[/TD]
[TD]01/01/2017
[/TD]
[/TR]
[TR]
[TD]123
[/TD]
[TD]0[/TD]
[TD]01/01/2017
[/TD]
[/TR]
[TR]
[TD]123
[/TD]
[TD]1
[/TD]
[TD]01/02/2017
[/TD]
[/TR]
[TR]
[TD]123
[/TD]
[TD]1
[/TD]
[TD]01/02/2017
[/TD]
[/TR]
[TR]
[TD]456
[/TD]
[TD]0[/TD]
[TD]01/01/2017
[/TD]
[/TR]
[TR]
[TD]456
[/TD]
[TD]0[/TD]
[TD]01/01/2017
[/TD]
[/TR]
</tbody>[/TABLE]

Not sure why it didn't display the "0" on rows 1, 2, 5, 6.

Thanks for any help or guidance!