impossible formula
 

http://www.savefile.com/files/1605447
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

impossible formula
 

It is unlikely anyone will open your file.
Try to tell us how the data is laid out and what you what to do
Make is simple and clear
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"sed" wrote in message
...
http://www.savefile.com/files/1605447
Ok so column L is filled with a bunch of zeros because the formula I used
didn't work. I want this column to be able to tell me if any person
(Database
id column F) has more than 5 "Call Id's" 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 Id's" 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