row of data within a time period

**jamesh2** · 07-01-2009, 11:42 AM

i have a row h, they are phone calls. if calls were made more than 3 times within 45 minutes i need to return the data on a seperate worksheet so i can see what phone numbers they were... i thought i could do a count if but its not helping, can anyone help? dates are in row b

**zbor** · 07-01-2009, 12:44 PM

Can you add one more helper columns like here?

Book111.xls

**jamesh2** · 07-01-2009, 12:47 PM

im sorry i dont understand what you mean, i can add as much as i want to this, as long as the result is correct

**kimbal** · 07-01-2009, 12:49 PM

Hi James
is it something like this?
The "result" sheet is filtered

**jamesh2** · 07-01-2009, 12:52 PM

no it just has the dates called in one column. so 7/15/09 12:54pm

**kimbal** · 07-01-2009, 01:13 PM

Is it something like this?
You need to press F9 in order to refresh for current time

**jamesh2** · 07-01-2009, 01:16 PM

yes!
now how would i make it tell me what phone it was that had the 3>

**kimbal** · 07-01-2009, 01:24 PM

I made a correction on formula in E,
and added a custom autofilter on it.
Please refer to the image below

**contaminated** · 07-01-2009, 06:55 PM

Hey jamesh2
please take a look at this table. I have wasted too much time for that LOL.
There're hidden coumns... u'll see when u download it.
Tell me what's wrong.