I need to find the value of the last and next to last entry in a row.

[FreezFrame]

I have a sheet with items entered into a row in pairs but in different cells. For example: 2 B , 3 B or 3 C. As they are entered I need to know what the last PAIR entered in an array is. This case I would need to scan the row from the left to the right and ignoring any blank spaces tell me that 3 and C were the last pair entered. I need to know this to be able to tell if either of them has regressed. If one has gone from a 3 to a 2, I need to reset my counter, same if the C was to regress to a B.
This a kind of grade book with each grade being two parts. I am trying to conditional format a another cell when the required grade has been reached. In this case a 3 and C. But the next time its graded....If it regresses in either of those areas, I need to change the conditional format.
I hope I've adequately described what I need!
MikeBook1.xlsx

[hemesh]

first of all you need to unmerge the Row 20 and Row 21
Keep you data in row number 20
then to check the last entry of number try below
=INDEX(AC20:BT20,MATCH(1000,AC20:BT20)) expand the reference if required and use =INDEX(AC20:BX20,MATCH(1000,AC20:BX20))

then to check the last Text Entry try below
=INDEX(AC20:BT20,MATCH("ZZZZZZZZZZZ",AC20:BT20)) expand the reference if required and use =INDEX(AC20:BX20,MATCH("ZZZZZZZZZZZ",AC20:BX20))

Hope this helps

[FreezFrame]

This works perfectly. I tried a lot of different methods. I guess I need to learn more about the index function! THANK YOU hemesh!!!!

[hemesh]

Thanks for the feedback