Selecting the latest value

[dmac13]

Hi,

i'm hoping someone can help, i have a spreadsheet with monday to friday in columns A1:E1 and the days values shown in the rows below. I want to be able to show the latest days value in column F.

Not all days will have a value, i just need to show the latest for example if a row shows :-

Monday - 100
Tuesday - 233
Wednesday - 50

i need column F to display 50.

or

Monday - 100
Tuesday - 300
Wednesday -
Thursday - 240

I need column F to show 240


Cheers
D

 

[VoG]

Try

=LOOKUP(9.9E+307,A2:E2)

 

[dmac13]

thanks that works a treat

can you explain how it is working if its not to much trouble not quiet sure what the 9.9E+307 is doing

thanks

D

 

[VoG]

This should help http://www.xldynamic.com/source/xld.LastValue.html

 

[dmac13]

thanks

is there a way you can get the formual to skip zero's 0 the current formula is showing 0 for the following where as i would want to return 59 :-

Monday - 40
Tuesday - 30
Wednesday -59
Thursday - 0
Friday 0