Why not throw the data in a pivot table and count the records?
--
Dan
Office 2007


"sed" wrote:

Ok so column L is filled with a bunch of zeros because the formula I used
didnt work. I want this column to be able to tell me if any person (Database
id column F) has more than 5 €œCall Ids€� at the same time. The example I
typed was not real it just showed the scenario. But my point is that a
€œDatabase ID€� can only have 5 €œCall Ids€� or less at one time.
Example:

hroesner
03/11/08-03/22/08 call id: 45468 PROBLEM
03/12/08-03/15/08 458488
03/22/08/-03/22/08 154878
03/19/08-03/21/08 848484
03/11/08-03/11/08 4864896
03/11/08-03/11/08 4864566

The problem here is that during this time frame hroesner had 6 call ids open
at ONE TIME. I need the formula to tell me €œPROBLEM€� for every single user
that this applies to. Sorry if I'm confusing, and thank you so much for
helping me. letme know if this helps

--
sss


"Don Guillett" wrote:

Still doesn't tell us what you want. And, your example here is not shown
there. ......

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"sed" wrote in message
...
http://www.savefile.com/files/1605447

--
sss


"Don Guillett" wrote:

Give us the detail and layout

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"sed" wrote in message
...
I have been trying to figure out how to build this formula for a week!
I need to figure out if a person has been assigned more than 5
"Tickets"
at
any given time. If I could send the file to anybody it would be of
IMMENSE
help!!!

--
sss