+ Reply to Thread
Results 1 to 3 of 3

Grabbing average from chart corresponding to newest dates with a numerical input cell

  1. #1
    Registered User
    Join Date
    08-05-2013
    Location
    Los Angeles
    MS-Off Ver
    Excel 2013
    Posts
    12

    Grabbing average from chart corresponding to newest dates with a numerical input cell

    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!!

  2. #2
    Forum Contributor
    Join Date
    03-11-2013
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    107

    Re: Grabbing average from chart corresponding to newest dates with a numerical input cell

    The attached file should help you out.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-05-2013
    Location
    Los Angeles
    MS-Off Ver
    Excel 2013
    Posts
    12

    Re: Grabbing average from chart corresponding to newest dates with a numerical input cell

    Great. Thanks a ton!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Dates seem formatted correctly, but will not sort newest to oldest.
    By MelindaCapri in forum Excel General
    Replies: 6
    Last Post: 02-11-2015, 02:34 PM
  2. Date input as relative referencing to create average between two dates
    By KorreSporre in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-12-2013, 07:31 AM
  3. [SOLVED] vba to sort columns according to dates in header from oldest to newest.
    By rocksan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-25-2012, 12:57 AM
  4. Replies: 2
    Last Post: 03-24-2011, 09:42 AM
  5. index/match only newest dates
    By scabertrain in forum Excel General
    Replies: 5
    Last Post: 09-27-2010, 05:16 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1