Results 1 to 3 of 3

How to use Arrays in Functions like LARGE / Conditional Range

Threaded View

  1. #1
    Registered User
    Join Date
    07-16-2014
    Location
    UK
    MS-Off Ver
    2016
    Posts
    90

    Red face How to use Arrays in Functions like LARGE / Conditional Range

    Please take a look at the spreadsheet.

    1. I have two arrays (array formula 1 & 2).
    And a large function which references the two arrays.
    =LARGE(I4:I5, 2)

    It does not work at all.
    What should I do?

    2. I want to calculate the sum of each section.
    The name "Check" or "Verify" acts like a separator to draw the border of each section (see the spreadsheet).
    Number of entries inside each section are not constant!

    xxx }
    xxx }
    xxx }-- Add all numbers
    Check ]
    xxx ]
    xxx ]
    xxx ]
    xxx ]-- Add all numbers
    Verify }
    xxx }
    xxx }-- Add all numbers

    The actual data is very long, so I need a way to define the range of each section by functions.
    What should I do?
    Last edited by mastertonn; 09-16-2014 at 07:51 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional Formatting Over a Large Range Not Working Properly
    By ExcelDavid in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-11-2014, 08:47 PM
  2. Replies: 3
    Last Post: 08-13-2013, 09:44 AM
  3. Using Large Formula on 2 arrays
    By afriedman in forum Excel General
    Replies: 11
    Last Post: 01-20-2011, 08:12 PM
  4. Automatic Sort with VLOOKUP/LARGE Functions-referencing a range
    By G in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-24-2005, 04:05 PM
  5. VBA - Large Arrays
    By ajocius in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-03-2005, 01:05 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