#1
|
|||
|
|||
add counter everytime a 1 appears in a cell
hi,
I have a cell that shows 1, every time a random number matching that cell is generated. for example if cell A1 = 1, and a rand function shows 1 in cell B1, then cell C1 will show 1. I want to keep incrementing C1 every time cell B1 shows 1, if B1 =0 then the value of C1 must remain same as previous value. its like adding a counter and it only add's up by 1 when the value of cell B1 is 1, otherwise it does not count but also does not reset. |
Tags |
adder, counter, random |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Would like animation everytime screen appears | tutto | PowerPoint | 0 | 09-22-2015 06:14 AM |
SpellChecker Everytime I open File | spatio | Word | 1 | 07-29-2015 08:16 PM |
powerpoint slide hit counter | breisleach | PowerPoint | 7 | 08-30-2013 12:25 AM |
Change cell color everytime a value is selected in dropdown list | angelica_gloria | Excel | 4 | 01-27-2012 06:47 PM |
Visitor counter on my webpage in Word | jwhbos | Word | 0 | 02-13-2010 04:21 AM |