Find and return a specific number

[Solved/Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
801
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?
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month