Ranking/Ordering System Formula

[GradyJohn]

Hi All,

I need some help creating a ranking/ordering system for a university project.

I have trucks entering a site multiple times per day, over 1 month, there are about 1500 truck entries and exits.

I need to rank these trucks from the first time they entered per day per shift.

Each shift is broken into Days and Nights. Days = 6am to 6pm, Nights = 6pm to 6am.

Factors that need to occur:



* If a truck enters more than once in a shift per day, its rank is not counted. Only its first entry is.
* If a new truck enters and meets the requirements, its rank is +1 from the last value (do not count blanks)
* A New Day that is not in the same shift results in starting at 1 again. If it is overnight on the same night, it is a +1 for new trucks.

Here is an example of what I mean