Get average excluding the last value.

[ihrktho]

Dear all,

I have a question about average within VBA code.

I need to get the average of values as follow:

A1 : 2
A2: 4
A3 : 8
A4 : 3

I would like to get the average from A1 to A3 excluding the last value in A4.

Tomorrow, I'll add a value in A5 so I would need the average range to dynamically adjust to A1:A4, excludign A5.


I use

Please Login or Register  to view this content.

It is probably an easy one, but I am fairly new to VBA,
Thanks for your time,
-Thomas

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[ihrktho]

Thanks john.

is end(3)(0) = end(xlup) ?

[JOHN H. DAVIS]

You're welcome. Glad to help out.

(3) = (xlUp)
(0) = an offset command for one row above the last cell in the column with data.

[JOHN H. DAVIS]

If you're satisfied then don't forget to comply with Forum Rule No. 9.

9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

[ihrktho]

I'll do it straight away. Thanks again for your help.