Results 1 to 4 of 4

reduce time needed to complete expanding an array formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-06-2021
    Location
    Tripoli
    MS-Off Ver
    Still using 2007 in 2023
    Posts
    291

    Wink reduce time needed to complete expanding an array formula

    Hello guys,
    Here we meet again.
    My only enquiry is that the array formula located inside my matrix would need an approximately 11 hours to be expanded across all cells.
    Is there any amendments to the formula or any faster approach to handle this heavy computation.
    I attach a sample of my sheet, but my original matrix contain 500 row items * 500 column items..

    Please refer to my excel to see the array formula inside the grey colored matrix.

    Thanks a lot in advance.
    Attached Files Attached Files
    Last edited by hasan mougharbel; 08-26-2022 at 07:25 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Reduce array references in formula
    By bmcdon in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-12-2022, 08:02 AM
  2. Replies: 2
    Last Post: 02-18-2022, 11:23 AM
  3. [SOLVED] Expanding array formula to include another column
    By Coyote_e in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-11-2019, 11:11 AM
  4. Replies: 1
    Last Post: 11-22-2016, 01:54 AM
  5. Replies: 9
    Last Post: 09-17-2014, 07:31 AM
  6. Reduce run time by switching a For loop into an array
    By Hallet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-04-2012, 01:21 PM
  7. [SOLVED] Need an Expanding array formula
    By havocdragon in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-05-2005, 06:05 AM

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