Excel 2010 IF statement help

DReborn

Limp Gawd
Joined
Aug 11, 2004
Messages
364
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
 
Back
Top