Returns last number

  • Thread starter Thread starter Colin
  • Start date Start date
C

Colin

Hello all,

I have equipment that gets tested daily which I receive
in spreadsheet form which looks like this:


1 2 3 4 5
12-May-04
13-May-04 192
14-May-04 23.5
15-May-04
16-May-04 117
17-May-04 249
18-May-04 191
19-May-04


I want to be able to add a link to another sheet which
returns only the number from the the latest date.

Thank you

Colin
 
Hi,

Not sure if i understood fully what you want. If you want the number of
the latest date to be displayed in a cell, use

=SUMPRODUCT((A2:A9=MAX(A2:A9))*(B2:D9))

(assuming that A2:A9 is the range where you have dates and B2:D9 is the
range where you have the numbers.

Regards

Govind.
 
Back
Top