hi all, just cutting my teeth into the higher level of Excel and need some help.
I want to create a template ultimately to do three things:
1. calculate the avg value of a column of numbers (in attachment column "SqFtPrice")
2. calculate the median value of the same column of numbers
3. and finally for the more complicated issue: I want to pull out rows that are a certain amt UNDER the avg and median prices. For instance, the average value comes out to $200, I would want to pull out line items (the whole row) that are $10, $20, $30 below that avg value and place those rows in their own section on the sheet.
I will be copying the excel data from a txt file that will always have different amount of information so I want a dynamic template that could adapt to the different data. i attached a sample txt file to see what I mean.
i know it's a lot, but would love a nudge in the right direction!
thanks!
Attachments
http://www.mediafire.com/?hdn0w6aqia7akwh
http://www.mediafire.com/?28ru7jc1wi1y63v
I want to create a template ultimately to do three things:
1. calculate the avg value of a column of numbers (in attachment column "SqFtPrice")
2. calculate the median value of the same column of numbers
3. and finally for the more complicated issue: I want to pull out rows that are a certain amt UNDER the avg and median prices. For instance, the average value comes out to $200, I would want to pull out line items (the whole row) that are $10, $20, $30 below that avg value and place those rows in their own section on the sheet.
I will be copying the excel data from a txt file that will always have different amount of information so I want a dynamic template that could adapt to the different data. i attached a sample txt file to see what I mean.
i know it's a lot, but would love a nudge in the right direction!
thanks!
Attachments
http://www.mediafire.com/?hdn0w6aqia7akwh
http://www.mediafire.com/?28ru7jc1wi1y63v