Impossible Formula

S

sed

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!!!
 
S

sed

http://www.savefile.com/files/1605447

What i need to do is figure out if any user has more than 5 call ids at any
time. Nobody is allowed to have more than 5 and if that happens i need to
know. You can add another sheet if you need to. Thanks a lot!

Example:

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

Don Guillett

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

sed

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
 
D

Dan

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


sed said:
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
Click to expand...
 
Top