CELL REFERENCE MATH

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Exel to analyze mechanical test date. The data files can be
600 to 6000 points. I need to capture an 50 point average at the 25%
and 75% points in the data. Is there a way to auto adjust where the
averages are taken based upon the number of data points. I can get the
number of data points using the COUNTIF function. Is there a way to
add this result as the numeric part of a cell reference and do the
appropriate math to select the correct ranges. I hope this explanation
makes sense.
 
Don't multipost. Either post in *ONE* newsgroup only or *CROSSPOST* to
several newsgroups at the same time. Multiposting, which means posting the
same message to several newsgroups separately, wastes everyone's time.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell Reference Math 5
cell reference math 1
pivot tables - totals different than the summarize function 1
Cell reference math 6
Formulas - Daily average at the specific date 3
Cross reference 1
Averaging unique values 2
Formula to average last 25 entries in a column? 4

Back
Top