okay, one one worksheet, I have many columns but three are important:
A=percent of an effect (number)
B=variable (number)
C=type of product (text)
I would like to look at each product and separate the percents (column A) into categories and then take the data from column B and average only that data within a certain percent range and for a certain product. I would like to get one number, the average, in return. I would like to insert this averaged data onto another worksheet in the workbook. How would I do that, without having to separate the first worksheet into many (I have soo much data on that page it would take days to separate).
What should I do?
2006-07-14
21:56:43
·
4 answers
·
asked by
Anonymous
in
Software