Prioritize importance

[samwalsh]

Currently the priority column is blank, but I would like to have it look like below. Trying to figure out how to get the order of importance starting from 1 and up and then 1 again once it goes to a different " Line #" only when the "status" is listed as OverDue otherwise it will just transfer over what is in the "Status" column. Gave up after not being able to get this to work

=IF(C2<>"Scheduled",C2,IF(A2<>A1,1,IF(B2<>B1,IF(ISNUMBER(E1)=TRUE,E1+1,1))))

Line	Setup	Status	Work #	Priority
Line 2	8867	Done	abc123	Done
Line 2	8869	Done	abc124	Done
Line 2	8869	At Line	abc125	At Line
Line 2	8870	OverDue	abc126	1
Line 2	8870	OverDue	abc127	1
Line 2	8871	Done	abc128	Done
Line 2	8875	Ready	abc129	Ready
Line 2	8875	Ready	abc130	Ready
Line 2	8875	Ready	abc131	Ready
Line 2	8875	Ready	abc132	Ready
Line 2	8876	OverDue	abc133	1
Line 2	8877	OverDue	abc134	2
Line 2	8877	OverDue	abc135	1
Line 2	8877	OverDue	abc136	1
Line 2	8877	OverDue	abc137	1
Line 2	8883	OverDue	abc138	2
Line 2	8883	OverDue	abc139	2
Line 2	8884	OverDue	abc140	3
Line 8	9366	Done	abc142	Done
Line 8	9367	At Line	abc143	At Line

<tbody>
</tbody>