|
Impossible Formula
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 |
Impossible Formula
Upload the file here and post the link
http://savefile.com/ Mike "sed" wrote: 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 |
Impossible Formula
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 |
Impossible Formula
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 -- sss "Mike H" wrote: Upload the file here and post the link http://savefile.com/ Mike "sed" wrote: 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 |
Impossible Formula
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 |
Impossible Formula
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 |
Impossible Formula
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 |
| All times are GMT +1. The time now is 02:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com