|
PureBytes Links
Trading Reference Links
|
Alex is quite correct - my bad - I misunderstood........ "How do I discover
that A2 contains the last value in the column?"
....to mean that Colin wanted A2 returned rather than what was in it. As
Alex said, drop the ROW function to return the cell's contents instead of
the value of the row number.
Waking up at 2:30 a.m to trade on Eurex is not conducive to speed reading
:-).
Rgds,
Kim
----- Original Message -----
From: "Alex Matulich" <alex@xxxxxxxxxxxxxx>
To: "cwest" <cwest@xxxxxxxxxxxx>
Cc: <omega-list@xxxxxxxxxx>
Sent: Thursday, June 26, 2003 2:24 PM
Subject: Re: Excel question
> >Thanks to everyone who helped me with my spreadsheet. Gotta crown Kim as
> >the Excel guru on the list ;)
>
> But what Kim suggested won't quite do what you want. Kim's suggested
> using the row number as the divisor, whereas you wanted the value inside
> the bottom cell of your column to be the divisor.
>
> >Assuming the values in the column will always contain numeric values,
> >
> >=ROW(OFFSET(A1,COUNT(A:A)-1,0))
> >
> >will return the value of the last non-blank row in column A.
>
> No, it returns the row number of the last non-blank row in column A,
> not the value in the cell. If you want the value, you don't need
> the ROW function.
>
> >So your formula X/A2 will be =X / ROW(OFFSET(A1,COUNT(A:A)-1,0))
>
> The formula should be =X/OFFSET(A1,COUNT(A:A)-1,0)
>
> That will use the value in the last cell in the colum, rather than the
> row number of that cell.
>
> -Alex
>
|