Sean, I'm glad you brought the row number up. It will help me illustrate my point.

RegionProgYearRiskNonRiskFlagMFGLeaseCycleModelName

Southeast 12 R NIS 1 ALTIMA S

The way it is written now, the code will group by the six columns above but it needs to group on seven columns. The returndate is the seventh column. Even though your code partitions on returndate (I think), it will only number the grouping above starting with one. I will not number the grouping based on return date (since it is blank). For example:

Group1 (based on six columns)

1

2

3

Group2

1

2

3

as opposed to:

Group1 (based on seven columns)

returndate1 (sub group1)

1

2

3

returndate2

1

2

3

returndate3 (etc)

I hope it makes sense. If not, I'll send you some data to work with.