Need formula for last cell filled in on a row

  • Thread starter Calculation of Text
  • Start date
C

Calculation of Text

I have linked worksheets where there is a row of values on one sheet where a
person's weight is entered (eg., each column is a week and there is a weight
entered for each week for 12 weeks).

We want the other worksheet to just show the latest entry, so that it can be
printed and sent out.

How can I make this Workbook "smart" enough to know?
 
B

Biff

Hi!

This will return the last numeric value entered on Sheet2 from row 1:

=LOOKUP(9.99999999999999E+307,Sheet2!1:1)

If no numeric values are found it will return #N/A.

Biff
 
Top