You should see the one I just cranked out....
Used the Seniority Number to find the person, then took advantage of the "Match" function to determine the rank more directly. Then had to figure out
VB code to run a button on a different sheet.
Now to figure out how to count the valid pilots and tell someone if they are too old...
Edit: Got it. Did that with the CountIF function....