So I have a list (rent roll specifically) of hundreds of units and what the current prices of each unit is. I have an =averageif formula to grab such data to return the average price of each unit. A list of mine would look something like this:
Unit Number Unit Type Current Rent Lease-Start
1 A1 1300 7/12/2013
2 A2 1250 1/1/1995
3 A1 1400 3/7/2006
4 A1 1500 5/7/2009
However, now I want just the average of just the two newest leases (for this case two, but I want to have an input cell where I can change the number to, let's say the newest one-hundred or fifty leases). How can I have a number correspond to finding X amount of newest dates, and, in addition, grab the average number from the cell that corresponds to the newest leases?
Bonus points if you can also solve this follow-up issue: Let's say I have the above data but 100 rows of data. Let's say I want to extract the average prices of the 50 newest leases, but the the newest lease #'s 48,49,50,51 and 52 have the same Lease-Start date. How can I include all of these in the top 50, even though technically it would be the top 52?
Thanks in advance!!
Bookmarks