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?

MRN	Episode	FDOS
123		01/01/2017
123		01/01/2017
123	1	01/02/2017
123	1	01/02/2017
456		01/01/2017
456		01/01/2017

<tbody>
</tbody>

 

[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?

MRN	Episode	FDOS
123	0	01/01/2017
123	0	01/01/2017
123	1	01/02/2017
123	1	01/02/2017
456	0	01/01/2017
456	0	01/01/2017

<tbody>
</tbody>

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

Thanks for any help or guidance!