Rank by flight

For the "rank within a flight" to work, I need to create two different formulas for row 1 to 4 and 5 to 8 separately. I was trying to create a fits-all formulat in the 4th column of the following spreadsheet. I tried using array function and it did not work. Please help.

By the way, how to align the columns so it's more legible? It's my first time, sorry.

Rank Rank
Flight Scores Full Field Flight
A 78 1 1
A 92 6 4
A 90 4 3
A 88 2 2
B 91 5 2
B 98 7 3
B 89 3 1
B 100 8 4

Please help. Thanks.