+ Reply to Thread
Results 1 to 3 of 3

Excel 2010 Ran out of resources while calculating error (but not in 2007)

Hybrid View

wilki24 Excel 2010 Ran out of... 06-26-2012, 12:43 AM
wilki24 Re: Excel 2010 Ran out of... 06-30-2012, 04:01 AM
olasa Re: Excel 2010 Ran out of... 07-02-2012, 08:02 PM
  1. #1
    Registered User
    Join Date
    06-26-2012
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    2

    Excel 2010 Ran out of resources while calculating error (but not in 2007)

    I have a formula that works in Excel 2007, but when I load it into Excel 2010, I get this error:

    "Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated."

    Here is the formula:
    {=IF(SUM(E10:E61)<1,"N/A",AVERAGE(SMALL(INDIRECT("E"&LARGE(ISNUMBER(OFFSET(E10,0,0,MATCH(1000,E10:E61),1))*ROW(OFFSET(E10,0,0,MATCH(1000,E10:E61),1)),ROW(INDIRECT("1:"&MIN(COUNTA(E10:E61),20))))),ROW(INDIRECT("1:"&MIN(COUNTA(E10:E61),10))))))}
    What it's doing is reading values in a column, which may have blank entries in between values and/or a variable number of entries, taking only the bottommost 20 values, then finding the smallest 10 of those, and averaging them for the result.

    Does anyone have any ideas on how I can fix this?

    Thanks!

  2. #2
    Registered User
    Join Date
    06-26-2012
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Excel 2010 Ran out of resources while calculating error (but not in 2007)

    I'm attaching the spreadsheet in question. I'd really appreciate any help that I can get on this, as as solution has proven to be most elusive.

    Thanks!
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256

    Re: Excel 2010 Ran out of resources while calculating error (but not in 2007)

    Sorry to say, Excel 2010 is not quite a stable product, yet.
    Quite often I have to revert to Excel 2007.

+ Reply to Thread

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