Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-31-2023, 09:23 PM
GradyJohn GradyJohn is offline Ranking/Ordering System Formula Windows 11 Ranking/Ordering System Formula Office 2021
Novice
Ranking/Ordering System Formula
 
Join Date: Oct 2023
Posts: 1
GradyJohn is on a distinguished road
Exclamation 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

Attached Images
File Type: png excelissue.PNG (33.5 KB, 9 views)
Reply With Quote
  #2  
Old 11-01-2023, 12:38 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Ranking/Ordering System Formula Windows 10 Ranking/Ordering System Formula Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,747
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
Reply

Tags
ordering system, ranking

Thread Tools
Display Modes


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
Ranking/Ordering System Formula 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
Ranking/Ordering System Formula Numerical ordering katejmchugh Excel 1 08-09-2011 12:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:29 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft