From: Willie Strickland <cwskas@earthlink.net>

Date: November 22, 2009 2:33:58 PM MST

To: Astro_IIDC@yahoogroups.com

Subject: Re: measuring brightness


--- In Astro_IIDC@yahoogroups.com, "cwskas" <cwskas@...> wrote:

Now, if there are any Numbers gurus out there, please contact me via the email below.  I want to improve the spreadsheet and cant figure out how to do what I want.




Below is an example of the results section of my spreadsheet.  What I want is to enter the value of the last frame (actually the last row with data in it) once in F2 and have that value used to set the range for calculation in G2, H2 & I2.


It would be fantastic if the spreadsheet could identify the last row in column F with data in it.  Those 2 options would mean that any amount of data could be pasted into A2 and that would be all that is required for results.


Willie



Mail Attachment



Here are the formulas


G2  =B1802-B2

H2  =AVERAGE(D2:D1802)

I2  =MEDIAN(D2:D1802)