(Msg. 1) Posted: Wed Feb 25, 2004 4:06 am
Post subject: average of Nth to Mth non null value Archived from groups: microsoft>public>excel>datamap (more info?)
Hello,
I am currently working on a table that looks like this
(only with 400+ rows):
| X Y Z
---------------------
A | 2.3 4.1
B | 1.1 1.3 1.3
C | 3.0 7.8
D | 4.6 2.3 1.1
E | 3.4
---------------------
I want to calculate the average, per column, of the Nth
to Mth (ex 2nd to 3rd) non empty column-cells.
In the example above,
Avg for X is Average of 1.1 and 4.6,
Avg.for Y is Average of 3.0 and 2.3.
Would anyone know how to do that without using new,
purged tables for each column?
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum