Countif

[Booman]

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

 

[Pete_UK]

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

 

[Booman]

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]

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