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.
Bookmarks