Results 1 to 7 of 7

How to apply correctly INDIRECT in array with long formulas

Threaded View

Franky alta How to apply correctly... 06-28-2015, 02:28 PM
jhren Re: How to apply correctly... 06-28-2015, 03:34 PM
Franky alta Re: How to apply correctly... 06-28-2015, 03:54 PM
jhren Re: How to apply correctly... 06-28-2015, 04:04 PM
Franky alta Re: How to apply correctly... 06-28-2015, 04:52 PM
jhren Re: How to apply correctly... 06-28-2015, 05:09 PM
Franky alta Re: How to apply correctly... 06-28-2015, 05:13 PM
  1. #1
    Registered User
    Join Date
    06-21-2015
    Location
    fort lauderdale, florida
    MS-Off Ver
    2007
    Posts
    77

    How to apply correctly INDIRECT in array with long formulas

    Hi,

    a moments ago I posted a tread on how to apply to non contiguous columns INDIRECT SUM.. <- was SOLVED

    But now i have a new question,
    i need to apply the same INDIRECT in to a long array formulas.
    my main purpose is to keep at all the time the same cell references with formulas that is applied to dynamic range.
    (i have to apply INDIRECT in a hundreds of cell that use different formulas)

    this is the working formula that i'm using, and i have no clue where to apply the INDIRECT function or how many times and in 'where'..

    =MIN(IF("$E37:$I1255=$AN$35",ROW("$C37:$C888")-ROW("$C37")+0)))

    Thank you
    Last edited by Franky alta; 06-28-2015 at 02:31 PM. Reason: add a coment

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to apply correctly SUM INDIRECT to non continuous column?
    By Franky alta in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-28-2015, 02:17 PM
  2. Long Array Formulas Using VBA
    By jiver1 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-20-2013, 03:11 PM
  3. Array Formulas taking too long to calculate
    By CheeksExcelForum in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-17-2013, 06:56 PM
  4. the use of indirect in array or sumproduct formulas
    By JoshuaSQ in forum Excel General
    Replies: 8
    Last Post: 12-18-2008, 12:09 PM
  5. Array Formulas take waaaay too long...
    By belly0fdesire in forum Excel Formulas & Functions
    Replies: 39
    Last Post: 09-06-2005, 07: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