Hello Every one,
I have got a requirement where we have to show number of open tickets every day. Each support ticket has unique id and an open date and closed date(if the ticket is closed). Attached is the sample excel which contains sample data-set we have and an expected output. Comment section provides reason of count in expected output.
Please suggest if more information is required and Thanks in advance
duplicated here
https://www.excelforum.com/excel-gen...ml#post5283730
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Administrative Note:
Welcome to the forum.
Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.
Please see Forum Rule #5 about thread duplication.
I am closing this thread, but you may continue in the other thread, where you have responses.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks