#1
|
|||
|
|||
Ranking/Ordering System Formula
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 |
#2
|
||||
|
||||
Hi please post a sample sheet. Pictures are useless to work with. Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Tags |
ordering system, ranking |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Re-ordering pages in a text-doc according to the headlines of the page | stoobz | Word | 5 | 09-02-2022 12:24 AM |
Simple question about ordering a table | Jehannum | Word Tables | 3 | 03-01-2021 05:39 AM |
System's firmware did not preserve system memory map | BW in Florida | Windows | 3 | 04-02-2016 04:00 PM |
Ranking with multiple criteria | angie.chang | Excel | 0 | 08-14-2012 04:49 PM |
Numerical ordering | katejmchugh | Excel | 1 | 08-09-2011 12:57 AM |