impossible formula

S

sed

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
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top