Results 1 to 6 of 6

Flexible Range Formula

Threaded View

  1. #1
    Registered User
    Join Date
    02-09-2010
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    5

    Flexible Range Formula

    I need a formula that will return the minimum value from a column range that flexs without having to manually go in an change row references. There is a blank row between each section of data in order to separate info.

    As an example:
    Assumes Column A
    Row 5 = 11
    Row 6 = 12
    Row 7 = 9
    Blank Row
    Row 9 = 12
    Row 10 = 11
    Row 11 = 15
    Row 12 = 6
    Row 13 = 11
    Blank Row

    Need to formula to flex to include rows 5 thru 7 in the first section but expand to include rows 9 thru 13 in the second section. =MIN(A5.A7) works but how do I get next section to flex to =MIN(A9.A13) without manually changing the cell references? There is always a blank row in between the sections to separate.

    Any help that you can send my way would be greatly appreciated.
    Last edited by sgrey24; 02-09-2010 at 06:18 PM.

Thread Information

Users Browsing this Thread

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

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