Closed Thread
Results 1 to 3 of 3

Very large workbook now giving incorrect results :(

  1. #1

    Very large workbook now giving incorrect results :(

    Grr!

    Excel is giving me incorrect results with certain areas of the
    workbook. I am using excel to analyse data by essentially counting
    instances in which certain criteria are met. I have the ability to
    check these results manually by autofiltering my data, and can confirm
    now that Excel is giving me completely incorrect results!


    Here it the formula in question:


    =SUM(((ISNUMBER(FIND("Se",'Supply Data'!$d$3:$d$2000)))*('Supply
    Data'!$i$3:$i$2000>$P$30))*('Supply Data'!$R$1=K273))


    This formula counts all instances in my raw data (Supply Data) that an
    entry has the letters 'Se', has a termination date greater than the
    beginning of the year, and is within a certain location. Trouble is, I
    can set the current year to be today, which SHOULD garauntee that the
    result is zero (as no one can have an entry greater than today since I
    am using historical data)... I end up getting 12, and nothing I can do
    changes this. After futzing around with the autofilter for many moons
    and double checking everything, suddenly the result will drop down to
    0.


    Is there any reason that Excel is mucking everything up? Any limitation

    to the amount of calculation the program can do before it starts
    misplacing things? FYI the workbook takes about 5.5 minutes to fully
    calculate new data, is 36MB in size, and has 33 sheets. PC is a 1.7Ghz
    with 512 RAM.


  2. #2
    Registered User
    Join Date
    12-28-2011
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Very large workbook now giving incorrect results :(

    Cant comment without see-ing the Excel. Does it work well with lesser data ?
    --
    This is Mr. Banerjee from India

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Very large workbook now giving incorrect results :(

    palmist, this thread is over 5 years old.

Closed 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