B
Bart1976
Hello everybody,
I have a little problem with excel 2003.
I am working on a time sheet. And i want to let excel calculate ho
many numbers of the same kind are in one big row.
Example:
I have in one colum 91 cells (# days in one quater of a year)
In those cells are zero´s and ones´s. The restriction is that there i
a max. of 14 one´s in a row. And if there are 14 one´s in a row ther
should be 7 zero´s after that. But what is the best way to start. And
want to know how many periods of one´s there are.
I appreciate it very much if somebody could give me some tips
Thanks and bye
Bar
I have a little problem with excel 2003.
I am working on a time sheet. And i want to let excel calculate ho
many numbers of the same kind are in one big row.
Example:
I have in one colum 91 cells (# days in one quater of a year)
In those cells are zero´s and ones´s. The restriction is that there i
a max. of 14 one´s in a row. And if there are 14 one´s in a row ther
should be 7 zero´s after that. But what is the best way to start. And
want to know how many periods of one´s there are.
I appreciate it very much if somebody could give me some tips
Thanks and bye
Bar