Count in a cell, not an array
 

Hi all, I have a cell that its value is changing all the time. i.e., each 10
seconds, mark TRUE. I want to count the number of times TRUE appears in the
cell. How can I do it?

Thanks a lot

Count in a cell, not an array
 

Do it in the code that is updating the cell.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Anat27" wrote in message
...
Hi all, I have a cell that its value is changing all the time. i.e., each
10
seconds, mark TRUE. I want to count the number of times TRUE appears in
the
cell. How can I do it?

Thanks a lot

Count in a cell, not an array
 

Sorry...but i don't really understand.. (i'm new at this...)

"Bob Phillips" wrote:

Do it in the code that is updating the cell.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Anat27" wrote in message
...
Hi all, I have a cell that its value is changing all the time. i.e., each
10
seconds, mark TRUE. I want to count the number of times TRUE appears in
the
cell. How can I do it?

Thanks a lot

Count in a cell, not an array
 

What I mean is that there must be some code that is generating the changes
to that cell, so count at the point where the change is effected.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Anat27" wrote in message
...
Sorry...but i don't really understand.. (i'm new at this...)

"Bob Phillips" wrote:

Do it in the code that is updating the cell.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Anat27" wrote in message
...
Hi all, I have a cell that its value is changing all the time. i.e.,
each
10
seconds, mark TRUE. I want to count the number of times TRUE appears in
the
cell. How can I do it?

Thanks a lot

Count in a cell, not an array
 

First of all, thanks a lot for all the help... but as I still don't really
get it (usually i'm noy that stupid...really...), here is an exemple of what
I mean:
I have a cell: =if(mod(A1,5)=0,TRUE,FALSE).
This cells takes the data from another cell which is a clock showing the
values of seconds (so every 5 seconds I get a TRUE).
Could you show me how to make a cell which will count all the times TRUE
appeared?

Thanks a lot, really!

"Bob Phillips" wrote:

What I mean is that there must be some code that is generating the changes
to that cell, so count at the point where the change is effected.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Anat27" wrote in message
...
Sorry...but i don't really understand.. (i'm new at this...)

"Bob Phillips" wrote:

Do it in the code that is updating the cell.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Anat27" wrote in message
...
Hi all, I have a cell that its value is changing all the time. i.e.,
each
10
seconds, mark TRUE. I want to count the number of times TRUE appears in
the
cell. How can I do it?

Thanks a lot

Count in a cell, not an array
 

Okay, so what is driving the clock cell, what makes it change?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Anat27" wrote in message
...
First of all, thanks a lot for all the help... but as I still don't really
get it (usually i'm noy that stupid...really...), here is an exemple of
what
I mean:
I have a cell: =if(mod(A1,5)=0,TRUE,FALSE).
This cells takes the data from another cell which is a clock showing the
values of seconds (so every 5 seconds I get a TRUE).
Could you show me how to make a cell which will count all the times TRUE
appeared?

Thanks a lot, really!

"Bob Phillips" wrote:

What I mean is that there must be some code that is generating the
changes
to that cell, so count at the point where the change is effected.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Anat27" wrote in message
...
Sorry...but i don't really understand.. (i'm new at this...)

"Bob Phillips" wrote:

Do it in the code that is updating the cell.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Anat27" wrote in message
...
Hi all, I have a cell that its value is changing all the time. i.e.,
each
10
seconds, mark TRUE. I want to count the number of times TRUE appears
in
the
cell. How can I do it?

Thanks a lot