Impossible Formula

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

 

[Mike H]

Upload the file here and post the link

http://savefile.com/

Mike

 

[Don Guillett]

Give us the detail and layout

 

[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

 

[sed]

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

--
sss

Give us the detail and layout

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[Don Guillett]

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

 

[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

 

[Dan]

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

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