On Sun, 28 Feb 2010 22:46:01 -0800, panchal jignesh <panchal
wrote:

I have 20 (F19-F39) raws in Comlumn F,

in cell F4 - i am trying to us mathfunction to show altest value I put in
F19-F39. I am adding new values in column A (F19-F39) as I go. I want to see
the latest value added in F19-F39 in cell A4.

Hoe can I do? I am using this formula, but it doesnt work from F31 onward.

=IF(F390,F39,IF(F380,F38,IF(F370,F37,IF(F360, F36,IF(F350,F35,IF(F340,F34,IF(F330,F33,IF(F32 0,F32,))))))))

please reply on this address too, if possible



=LOOKUP(2,1/(F19:F390),F19:F39)

will return the last non-zero value in f19:f39

If it is possible for a value to be a zero, then:

=LOOKUP(2,1/(F19:F39<""),F19:F39)

might be better.

Also, if there will never be any blanks, you could also try:

=OFFSET(F18,COUNT(F19:F39),0)

--ron