Reg No | Class | PG | Nur | KG |
20 | PG | 3 | 2 | 1 |
25 | PG | |||
27 | Nur | |||
29 | KG | |||
30 | PG | |||
PG | ||||
Nur | ||||
35 | Nur |
You could also have added in response to post #2 that it's not what you are after. Curious though: If 30 in the record < 30, PG > would have been 25, would the result for PG still be 3?
This is reg no, it could be any number. If student registered in my branch than the registration number will be generated otherwise student would be Transferred In from another branch and registration number field would be blank.
However, i tried this but answer shown in C1 is 6.