How do you count how often a specific value occurs in single changing cell?

gebobs · #4 09-02-2014, 11:23 AM

Perhaps I don't understand. By "after the field changes" do you mean "after the result in A1 changes"?

If so, it works fine for me. When I double-click in another cell (other than A1 and A2), the rand() formula recalculates. If the result is less than 0.1, then the result in A2 becomes 1. Otherwise, the result in A2 is 0. A2 will equal 1 about 10% of the time.

Here is a my file. I made the condition "<0.5" so the condition will be met more often. If I am misunderstanding, please clue me in.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sum values within a single cell	shabbaranks	Excel	17	05-13-2014 06:47 PM
count how many tims a certain value occurs	lucnijs	Excel	6	03-26-2012 09:29 AM
How to count year lapse (rounded off) based on specific date	KIM SOLIS	Excel	1	11-01-2011 10:50 AM
How to count multiple values in a single cell, except zero?	iuliandonici	Excel	1	04-13-2011 09:45 PM
changing word count	hamster	Word	3	06-03-2010 01:53 AM