Closed Thread
Results 1 to 3 of 3

Strange Behaviour

  1. #1
    Forum Contributor
    Join Date
    United Kingdom
    MS-Off Ver
    EXCEL 2003 (2007 at home)

    Strange Behaviour

    I was fiddling with ideas in conection with Huwbob's problem "Check instances of values in a column" using the attached sheet.

    I noticed that as I re-calculated the random numbers, the result was not changing.

    I stepped through the calculation using the "Evaluate Function" feature, and the calculations are correct, until the final step!

    Any Ideas? (I am using Office 2007)

    Attached Files Attached Files

  2. #2
    Valued Forum Contributor ratcat's Avatar
    Join Date
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    G'day Mark,

    Yes it is odd behaviour and no ideas why that's doing it.

    But I try this formula

    Please Login or Register  to view this content.
    And put it through the "Evaluate Function" feature and it pass with flying colours. The sumproduct failed.

    I'm at a lost too

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    MS-Off Ver
    Xp; 2007; 2010
    Thread closed, too late for Editing.

    Mark you can re-ask this if you want with the correct format of title
    Hope that helps.

    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Strange cell behaviour
    By Portuga in forum Excel General
    Replies: 3
    Last Post: 02-28-2008, 10:03 AM
  2. Strange Texttocolumn behaviour
    By Mbrolass in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2008, 01:17 PM
  3. Strange Textbox value problem
    By mqdias in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-07-2007, 08:12 AM
  4. Excel ListBox strange behaviour
    By sean_f_howard in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-07-2007, 06:32 AM
  5. Replies: 0
    Last Post: 06-06-2007, 04:53 PM


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