# Find and return a specific number

Solved/Closed
JHstuck - Jan 27, 2010 at 08:25 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 27, 2010 at 08:24 PM
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

## 1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jan 27, 2010 at 08:24 PM
It is not clear what exactly you want at the end

see experimental data A1 to D5

name test1 test2 test3
a 3 3 1
s 2
d 3 1
f 3 2

now in E2 type this formula (or copy paste)

=IF(D2<>0,D2,IF(C2<>0,C2,B2))
copy E2 down
you will get

name test1 test2 test3 result
a 3 3 1 1
s 2 2
d 3 1 1
f 3 2 2
is this what you want?