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))))

[TABLE="width: 382"]
<tbody>[TR]
[TD]Line[/TD]
[TD]Setup[/TD]
[TD]Status[/TD]
[TD]Work #[/TD]
[TD]Priority[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8867[/TD]
[TD]Done[/TD]
[TD]abc123[/TD]
[TD]Done[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8869[/TD]
[TD]Done[/TD]
[TD]abc124[/TD]
[TD]Done[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8869[/TD]
[TD]At Line[/TD]
[TD]abc125[/TD]
[TD]At Line[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8870[/TD]
[TD]OverDue[/TD]
[TD]abc126[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8870[/TD]
[TD]OverDue[/TD]
[TD]abc127[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8871[/TD]
[TD]Done[/TD]
[TD]abc128[/TD]
[TD]Done[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8875[/TD]
[TD]Ready[/TD]
[TD]abc129[/TD]
[TD]Ready[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8875[/TD]
[TD]Ready[/TD]
[TD]abc130[/TD]
[TD]Ready[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8875[/TD]
[TD]Ready[/TD]
[TD]abc131[/TD]
[TD]Ready[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8875[/TD]
[TD]Ready[/TD]
[TD]abc132[/TD]
[TD]Ready[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8876[/TD]
[TD]OverDue[/TD]
[TD]abc133[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8877[/TD]
[TD]OverDue[/TD]
[TD]abc134[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8877[/TD]
[TD]OverDue[/TD]
[TD]abc135[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8877[/TD]
[TD]OverDue[/TD]
[TD]abc136[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8877[/TD]
[TD]OverDue[/TD]
[TD]abc137[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8883[/TD]
[TD]OverDue[/TD]
[TD]abc138[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8883[/TD]
[TD]OverDue[/TD]
[TD]abc139[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8884[/TD]
[TD]OverDue[/TD]
[TD]abc140[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Line 8[/TD]
[TD]9366[/TD]
[TD]Done[/TD]
[TD]abc142[/TD]
[TD]Done[/TD]
[/TR]
[TR]
[TD]Line 8[/TD]
[TD]9367[/TD]
[TD]At Line[/TD]
[TD]abc143[/TD]
[TD]At Line[/TD]
[/TR]
</tbody>[/TABLE]