Results 1 to 10 of 10

Dynamic Range For "SMALL" Function Then Offset LookUp

Threaded View

  1. #1
    Registered User
    Join Date
    03-07-2013
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    9

    Dynamic Range For "SMALL" Function Then Offset LookUp

    Hi,

    I have an annual budget that contains all the days in year, and various formulas calculating values.

    That bottom row of the table has a simple indicator to show if the day is in the past.

    Please see the attached demo of the layout...

    demo.xlsx

    I want a formula to create a dynamic range from "tomorrow" to the end of the sheet (J:V in the example) but this will move as the date changes.

    I will then use that range to return the 3 smallest values (A7:A9 in the example as today is 8th July), but I also want it to return the date that small value occurs on (B7:B9 in the example). If the small value occurs more than once, that it just needs to return the first and associated date.

    Row 1 contains the date to report, row 4 contains the balance to check and row 5 contains the day indicator.

    Many thanks.
    Last edited by david.nicholls; 07-09-2013 at 07:34 AM.

Thread Information

Users Browsing this Thread

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

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