Excel - How to organize complex data according to time with IF condition?

I have a spreadsheet contains students information and their choices for classes for new semester. the spreadsheet contains Timestamp column, student name column and 9 columns (first choice - ninth choice) under each column student choose one unique class from (A1,A2,A3,B1,B2,B3,C1,C2,C3) as shown in picture below.

example

Each class ( A1 : C3 ) has 10 places. i need to fetch the first 10 students for each class according to time and available places. For example if the student no. 15 choose in first choice A1 and A1 is completed then excel directly look at the second choice(B1) if it is available so it add to B1 and look for the next student or if it is not available so excel look for the third choice and so on.

Is it possible to apply this idea using conditional formatting or using IF condition?

I tried conditional formatting and find duplicate but it was incorrect.