View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Srikanth Ganesan[_2_] Srikanth Ganesan[_2_] is offline
external usenet poster
 
Posts: 14
Default Help wanted with computation

Hello,

I want to write a macro which actually computes the average of a number
of columns.

The excel file has data in the following format:
Column B has X axis data (of unknown number of rows)
Column C has Y axis data ( " )

Column E has Y axis data ( " )
Column F has Y axis data ( " )

and so on (total number of such pairs is not known before hand)

I want to compute an average X axis and an average Y axis So that I can
make an average plot of all the individual plots.
What is the best way to do that ?

Srikanth


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!