Find and return a specific number

Hello,

I am trying to find out how to display a specific number.

I have 3 columns, each showing a results from a test as follows:

3 =fail
2 =marginal pass
1 = pass

The person will only re-take the test a second time if they fail the first time. And if they fail twice, they have to take it a third time.

So my 3 columns could just show 1 or 2 in the first column and nothing in the second. Or they could show 3 in the first, and 1 or 2 in the second etc.

I want to run a macro or create a formula that looks accross the 3 columns, and displays the latest result, ie the answer in the last column.

Hard to explain, hope this makes sense...??

Thanks,

Julia