Reading the Latest Value into a cell

[Lee]

I have a worksheet where the user identifies a risk and then takes steps to
try and prevent the risk from happening. After the completion of each step
he reassess the Likelyhood and Consequence of the risk happening. I want to
have two cells that show me the latest information on the Likelihood and
Consequence of this risk which automatically update to reflect the latest
informaion as the user completes each step.

What is the best way to do this? In excel he marks each step as being
Completed so I can trigger off of that to read the values.

Thanks in advance

 

[Max]

Hazarding a guess here ..

Presuming "Likelyhood" & "Consequence" indications are text (eg: "Completed"
?), either selected or input in cols B and C progressively from row2 down
(Headers are assumed in B1:C1, eg: "Likelyhood", "Consequence"), then think
we could try:

Place in say, E1:
=IF(COUNTA(B:B)=1,"",INDEX(B:B,MATCH(REPT("z",255),B:B)))
Copy E1 to F1

E1 will return the last text value within col B ("Likelyhood")
while F1 returns the last text value within col C ("Consequence")