Hello Everyone. It's my first post so please be gentle
I'm using MS Excel 2007.
I'm a real estate appraiser and I'm trying to set up a template for my analysis that checks the sale dates from a period (say 10 years) and calculates the median sale price of each annual period. I've been doing this with pivot tables for a while and it works beautifully; however, it obviously can't calculate the median for me and the mean isn't acceptable for my work.
The problem I encounter is that I am dealing with large sets of data that I import into Excel from Access or from a .csv/.txt. The sets usually consist of between 1,000 - 3,000 records.
Here's what I'm trying to accomplish:
I have a worksheet in my workbook titled "Data", I dump all the records into this and insert them into a table. The fields have names typical of real estate databases (sold date, sold price, etc.). On another sheet I have a row of empty cells that I want to populate with the medians for each annual period. How do I create an array that will test the values in one field and calculate the median from the records that meet the criteria. So 01/01/00 >= 12/31/00 ... simple, I know, but I can't get it to work.
I tried using an AND statement and nested IF statements but I just can't get it to work.
Please help, I'm desperate
TYIA.
Mike
Bookmarks