Rotating List of Pilots

[TheJetSetPilot]

Good Afternoon,

I am a Pilot at a Flight School, and we have approximately 100 Students that we schedule to fly each week. I am trying to make a simple list of the names, that I can check off when have been booked for a Flight, and their name drops to the bottom of the list, and continually rotates up. That way each student receives a fair and equal number of flights. The challenge we have, is that it is not like a batting order, where the order of students always remains the same - i.e, Unavailablity, weather cancelations, time off, etc…

Any ideas would be greatly appreciated - Thank You in advance…!

 

[Joe4]

Welcome to the Board!

Why not just keep track of the number of flights in some column next to their name, and then sort that list by number of flights in ascending order?
Then the ones with the least number of flights will appear at the top.

 

[Joe4]

Excel 365 even has a SORT function you can use to make the sort dynamic, so you don't need to keep doing it manually.
See: SORT Function

 

[JamesCanale]

MrExcelPlayground17.xlsx
	A	B	C	D	E
1	Pilot Roster		Bookings		Up Next
2	Pilot 1		Pilot 1		Pilot 10
3	Pilot 2		Pilot 2		Pilot 11
4	Pilot 3		Pilot 4		Pilot 12
5	Pilot 4		Pilot 5		Pilot 13
6	Pilot 5		Pilot 6		Pilot 14
7	Pilot 6		Pilot 7		Pilot 15
8	Pilot 7		Pilot 8		Pilot 16
9	Pilot 8		Pilot 30		Pilot 17
10	Pilot 9		Pilot 1		Pilot 18
11	Pilot 10		Pilot 9		Pilot 19
12	Pilot 11		Pilot 3		Pilot 20
13	Pilot 12				Pilot 21
14	Pilot 13				Pilot 22
15	Pilot 14				Pilot 23
16	Pilot 15				Pilot 24
17	Pilot 16				Pilot 25
18	Pilot 17				Pilot 26
19	Pilot 18				Pilot 27
20	Pilot 19				Pilot 28
21	Pilot 20				Pilot 29
22	Pilot 21				Pilot 2
23	Pilot 22				Pilot 4
24	Pilot 23				Pilot 5
25	Pilot 24				Pilot 6
26	Pilot 25				Pilot 7
27	Pilot 26				Pilot 8
28	Pilot 27				Pilot 30
29	Pilot 28				Pilot 1
30	Pilot 29				Pilot 9
31	Pilot 30				Pilot 3
Sheet18

Cell Formulas
Range	Formula
E2:E31	E2	=SORTBY(Table9[Pilot Roster],IFNA(XMATCH(Table9[Pilot Roster],Table10[Bookings],0,-1),0))
Dynamic array formulas.

 

[TheJetSetPilot]

Gentlemen, Thank You…! I feel a bit like an idiot for not thinking of these solutions - if you are ever in Madrid, I owe you guys a flight.

 

[Joe4]

You are welcome.
Glad we were able to help!