I am trying to do a countif function that will show me repeats for 2 days
before and 2 days after through the whole workbook. I am trying to find the
number of repeats through a total of 5 days.


A1 B1
1/4/2008 6:26 2985
1/4/2008 6:27 29855
1/4/2008 6:27 2512
1/4/2008 6:28 20112
1/4/2008 6:28 2985
1/4/2008 6:29 2512
1/4/2008 6:29 454
1/4/2008 6:30 552
1/4/2008 6:30 454
1/4/2008 12:25 29855
1/4/2008 12:26 135
1/4/2008 12:26 1485
1/4/2008 12:27 8859
1/4/2008 12:28 8021
1/4/2008 12:28 3132
1/4/2008 12:29 454
1/4/2008 12:29 552

Not sure exacty what you want, but try this in C1:

=COUNTIF(B$1:B1,B1)

and copy down as required. It will give you a running total of each
value in B, so anything above 1 will indicate repeated values, and the
maximum for any value will indicate how many times that value occurs.

Hope this helps.

Pete

On Feb 5, 1:29*pm, Booman wrote:
I am trying to do a countif function that will show me repeats for 2 days
before and 2 days after through the whole workbook. I am trying to find the
number of repeats through a total of 5 days.

A1 * * * * * * * * * * * B1
1/4/2008 6:26 * 2985
1/4/2008 6:27 * 29855
1/4/2008 6:27 * 2512
1/4/2008 6:28 * 20112
1/4/2008 6:28 * 2985
1/4/2008 6:29 * 2512
1/4/2008 6:29 * 454
1/4/2008 6:30 * 552
1/4/2008 6:30 * 454
1/4/2008 12:25 *29855
1/4/2008 12:26 *135
1/4/2008 12:26 *1485
1/4/2008 12:27 *8859
1/4/2008 12:28 *8021
1/4/2008 12:28 *3132
1/4/2008 12:29 *454
1/4/2008 12:29 *552

How can I apply a countif through the whole workbook I'm trying to find the
repeat vaule of B1 through out the whole work book.

"Pete_UK" wrote:

Not sure exacty what you want, but try this in C1:

=COUNTIF(B$1:B1,B1)

and copy down as required. It will give you a running total of each
value in B, so anything above 1 will indicate repeated values, and the
maximum for any value will indicate how many times that value occurs.

Hope this helps.

Pete

On Feb 5, 1:29 pm, Booman wrote:
I am trying to do a countif function that will show me repeats for 2 days
before and 2 days after through the whole workbook. I am trying to find the
number of repeats through a total of 5 days.

A1 B1
1/4/2008 6:26 2985
1/4/2008 6:27 29855
1/4/2008 6:27 2512
1/4/2008 6:28 20112
1/4/2008 6:28 2985
1/4/2008 6:29 2512
1/4/2008 6:29 454
1/4/2008 6:30 552
1/4/2008 6:30 454
1/4/2008 12:25 29855
1/4/2008 12:26 135
1/4/2008 12:26 1485
1/4/2008 12:27 8859
1/4/2008 12:28 8021
1/4/2008 12:28 3132
1/4/2008 12:29 454
1/4/2008 12:29 552

Don't quite understand - do you mean that you want to see if 2985
(from your example) occurs anywhere else in any column, in any
worksheet in the workbook?

If so, that's a pretty tall order.

Perhaps you can describe what you have and what you want to achieve in
some more detail?

Pete

On Feb 5, 3:38*pm, Booman wrote:
How can I apply a countif through the whole workbook I'm trying to find the
repeat vaule of B1 through out the whole work book.



"Pete_UK" wrote:
Not sure exacty what you want, but try this in C1:

=COUNTIF(B$1:B1,B1)

and copy down as required. It will give you a running total of each
value in B, so anything above 1 will indicate repeated values, and the
maximum for any value will indicate how many times that value occurs.

Hope this helps.

Pete

On Feb 5, 1:29 pm, Booman wrote:
I am trying to do a countif function that will show me repeats for 2 days
before and 2 days after through the whole workbook. I am trying to find the
number of repeats through a total of 5 days.

A1 * * * * * * * * * * * B1
1/4/2008 6:26 * 2985
1/4/2008 6:27 * 29855
1/4/2008 6:27 * 2512
1/4/2008 6:28 * 20112
1/4/2008 6:28 * 2985
1/4/2008 6:29 * 2512
1/4/2008 6:29 * 454
1/4/2008 6:30 * 552
1/4/2008 6:30 * 454
1/4/2008 12:25 *29855
1/4/2008 12:26 *135
1/4/2008 12:26 *1485
1/4/2008 12:27 *8859
1/4/2008 12:28 *8021
1/4/2008 12:28 *3132
1/4/2008 12:29 *454
1/4/2008 12:29 *552- Hide quoted text -

- Show quoted text -