Need Help with a Formula

[BerrSD]

I need some help: In this example I have a column of 5 cells B1:B5. I
also have another cell C1. I would like to have cell C1 to display the
most recent entry in the B Column.

Start
B1=Null C1=Null
B2=Null
B3=Null
B4=Null
B5=Null

First Entry
B1=4 C1=4
B2=Null
B3=Null
B4=Null
B5=Null

Second Entry
B1=4 C1=7
B2=7
B3=Null
B4=Null
B5=Null

Third Entry
B1=4 C1=3
B2=7
B3=3
B4=Null
B5=Null

Fourth Entry
B1=4 C1=0
B2=7
B3=3
B4=0
B5=Null

Fifth Entry
B1=4 A1=9
B2=7
B3=3
B4=0
B5=9

Is there a formula that can do this? Thanks.


Bernard

 

[Don Guillett]

=max(b:b)

 

[Don Guillett]

OOPs
=INDEX(c:c,MATCH(9999,c:c))

 

[BerrSD]

OOPs
=INDEX(c:c,MATCH(9999,c:c))

I don't completely understand but will give it a try. Will let you know
of the results. Thanks.

Bernard

 

[BerrSD]

OOPs
=INDEX(c:c,MATCH(9999,c:c))

Thanks! If worked perfectly.

Bernard