Closed Thread
Results 1 to 3 of 3

Strange Behaviour

  1. #1
    Forum Contributor
    Join Date
    10-27-2006
    Location
    United Kingdom
    MS-Off Ver
    EXCEL 2003 (2007 at home)
    Posts
    517

    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)

    Mark.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111
    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
    Have I made you happy ??? If yes, please make me happy by pressing the http://www.excelforum.com/images/buttons/reputation-40b.png Add Reputation button in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks
    I don't void confusion, I create it

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Thread closed, too late for Editing.

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

    RoyUK
    --------
    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

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