What I am doing is creating a template. The user will have to copy/paste data from a separate spreadsheet into this template. There are 3 columns of data they'll have to paste. What the template should do is look at the first column (A) for a specified number (0). Then it should move to the second column (B) to find all numbers with in a range specified by column F, which are numbers. Ranges would look something like F36:F35, F35:F34, etc. So the range looks in column B for numbers between the numbers in F36 and F35. It then should Average the numbers in the corresponding cells of the range in column C. The equation and data will be placed in column G.
Columns A, B and C have to be dynamic because the amount of user input data may vary greatly. Also the data will be unsorted ... unless it will only work to have the data sorted. I'm not sure which will work best.
All I'm looking for is what functions I should be using, or could use.
... after thought,
Maybe I can just use nested If Then statements with a Sum/Count (or Average) statement?
Have to give that a shot I guess ...
Columns A, B and C have to be dynamic because the amount of user input data may vary greatly. Also the data will be unsorted ... unless it will only work to have the data sorted. I'm not sure which will work best.
All I'm looking for is what functions I should be using, or could use.
... after thought,
Maybe I can just use nested If Then statements with a Sum/Count (or Average) statement?
Have to give that a shot I guess ...
