combine or count data

chadlaw32

Board Regular
Joined
Jul 29, 2014
Messages
77
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
I am trying to write a formula that gives me a 1 if user, ticket, and time(within 10 minutes of each other) are the same. for example the second and third entries one of those would get a 1 the other would get a 0. Any ideas?

UserCreatedCommentTicket TypeTicket NumberLinkCategorySubcategory
Derrick McDonald7/30/2021 5:55Comment added 'Calling for update.'Incident
18144​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network Interface/CircuitDown
Derrick McDonald7/30/2021 5:54Comment added '137/142 online. Monitoring.'Incident
18417​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 5:54Name is 22 Modems Offline scsen002cme - cable-mac 22 CMAC-22; 'Assignee' changed from 'NOC' to 'Derrick McDonald'.Incident
18417​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 5:48Name is 11 Modems Offline scsen002cme - cable-mac 15 CMAC-15; 'State' changed from 'Resolved' to 'Closed'.Incident
18425​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 5:48Name is 11 Modems Offline scsen002cme - cable-mac 15 CMAC-15; 'State' changed from 'Recovered' to 'Resolved'.Incident
18425​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 5:48'Resolution Code' is 'Generic'.Incident
18425​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Eric Cookson7/30/2021 5:44Name is 11 Modems Offline scsen002cme - cable-mac 15 CMAC-15; 'State' changed from 'Pending Assignment' to 'Recovered'.Incident
18425​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Eric Cookson7/30/2021 5:43Name is 24 Modems Offline waeph001cmj - CATV-MAC 3 3A17A1; 'State' changed from 'Resolved' to 'Closed'.Incident
18426​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Eric Cookson7/30/2021 5:43Name is 24 Modems Offline waeph001cmj - CATV-MAC 3 3A17A1; 'State' changed from 'Updated' to 'Resolved'.Incident
18426​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Eric Cookson7/30/2021 5:43'Resolution Code' is 'Generic'.Incident
18426​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Eric Cookson7/30/2021 5:43Comment added 'BBX showing 65/66 modems are online. Potential polling issue.'Incident
18426​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Eric Cookson7/30/2021 5:42Name is 24 Modems Offline waeph001cmj - CATV-MAC 3 3A17A1; 'Assignee' changed from 'NOC' to 'Eric Cookson'.Incident
18426​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Eric Cookson7/30/2021 5:39Comment added 'Checking'Incident
18426​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Eric Cookson7/30/2021 5:39Name is 24 Modems Offline waeph001cmj - CATV-MAC 3 3A17A1; 'State' changed from 'Pending Assignment' to 'Assigned'.; 'Assignee' changed from 'Network Operations Center' to 'Eric Cookson'.Incident
18426​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 5:38Comment added 'Modems appear to be recovering. This appears to be flapping.'Incident
18417​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 5:37File image.png uploadedIncident
18417​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 5:37File image.png uploadedIncident
18417​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 5:36Comment added '111/142 showing online. Checking power.'Incident
18417​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 5:36Name is 11 Modems Offline scsen002cme - cable-mac 15 CMAC-15; 'State' changed from 'Updated' to 'Recovered'.Incident
18425​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 5:36Comment added '104/106 online. Monitoring.'Incident
18425​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 5:35Name is 22 Modems Offline scsen002cme - cable-mac 22 CMAC-22; 'Assignee' changed from 'NOC' to 'Derrick McDonald'.Incident
18417​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 5:35Name is 11 Modems Offline scsen002cme - cable-mac 15 CMAC-15; 'State' changed from 'Pending Assignment' to 'Assigned'.; 'Assignee' changed from 'Network Operations Center' to 'Derrick McDonald'.Incident
18425​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 5:34Name is 23 Modems Offline scsen002cme - cable-mac 13 CMAC-13; 'Category' changed from 'Network Performance' to 'Network Outage'.; 'Subcategory' changed from 'Node Unresponsive' to 'Commercial Power'.; 'Region' is 'Southeast'.; 'City' is 'Seneca SC'.; 'Address/Node' is 'C30'.; 'Action Taken' is 'Verified Commercial Power Called On Call'.; 'Impacted Customers' is '23'.; 'Total Customers on Node' is '123'.; 'Time Zone' is 'Eastern Time'.; 'Power Company' is 'Duke Energy'.; 'Start Time' is 'Jul 30 2021 - 5:34AM'.Incident
18424​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageCommercial Power
Derrick McDonald7/30/2021 5:33Comment added ''Incident
18424​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageCommercial Power
Derrick McDonald7/30/2021 5:33File image.png uploadedIncident
18424​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageCommercial Power
Derrick McDonald7/30/2021 5:33File image.png uploadedIncident
18424​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageCommercial Power
Derrick McDonald7/30/2021 5:33Name is 23 Modems Offline scsen002cme - cable-mac 13 CMAC-13; 'Assignee' changed from 'NOC' to 'Derrick McDonald'.Incident
18424​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageCommercial Power
Derrick McDonald7/30/2021 5:30Comment updated 'Liberty SC'Incident
18424​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageCommercial Power
Derrick McDonald7/30/2021 5:30Comment added ''Incident
18424​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageCommercial Power
Derrick McDonald7/30/2021 5:30File image.png uploadedIncident
18424​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageCommercial Power
Derrick McDonald7/30/2021 5:30File image.png uploadedIncident
18424​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageCommercial Power
Derrick McDonald7/30/2021 5:30Name is 23 Modems Offline scsen002cme - cable-mac 13 CMAC-13; 'Assignee' changed from 'NOC' to 'Derrick McDonald'.Incident
18424​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageCommercial Power
Derrick McDonald7/30/2021 5:29Comment added '103/125 online per BBX. Checking power.'Incident
18424​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageCommercial Power
Derrick McDonald7/30/2021 5:29Name is 23 Modems Offline scsen002cme - cable-mac 13 CMAC-13; 'Assignee' changed from 'NOC' to 'Derrick McDonald'.Incident
18424​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageCommercial Power
Derrick McDonald7/30/2021 5:28Comment added 'Checking validity'Incident
18424​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageCommercial Power
Derrick McDonald7/30/2021 5:27Name is 23 Modems Offline scsen002cme - cable-mac 13 CMAC-13; 'State' changed from 'Pending Assignment' to 'Assigned'.; 'Assignee' changed from 'Network Operations Center' to 'Derrick McDonald'.Incident
18424​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageCommercial Power
Derrick McDonald7/30/2021 5:27Name is 17 Modems Offline lawlk001cmh - CATV-MAC 14 WL20(); 'State' changed from 'Resolved' to 'Closed'.Incident
18027​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 5:27Name is 17 Modems Offline lawlk001cmh - CATV-MAC 14 WL20(); 'State' changed from 'Flapping' to 'Resolved'.Incident
18027​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 5:27'Resolution Code' is 'Generic'.Incident
18027​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 5:24Comment added 'New ETR'Incident
18406​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageCommercial Power
Derrick McDonald7/30/2021 5:24File image.png uploadedIncident
18406​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageCommercial Power
Derrick McDonald7/30/2021 5:24File image.png uploadedIncident
18406​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageCommercial Power
Derrick McDonald7/30/2021 5:24Name is Master Ticket - 312 Modems Offline ncfrc001cme - cable-mac 43 50B1_N50; 'Assignee' changed from 'NOC' to 'Derrick McDonald'.Incident
18406​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageCommercial Power
Derrick McDonald7/30/2021 5:23Remove tags [Assignment Breach]Incident
18406​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageCommercial Power
Derrick McDonald7/30/2021 5:23Name is 21 Modems Offline ncfrc001cme - cable-mac 28 51B2_512; 'State' changed from 'Resolved' to 'Closed'.Incident
18404​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 5:23Name is 21 Modems Offline ncfrc001cme - cable-mac 28 51B2_512; 'State' changed from 'Updated' to 'Resolved'.Incident
18404​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 5:23'Resolution Code' is 'Generic'.Incident
18404​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 5:23Name is 29 Modems Offline ncfrc001cme - cable-mac 55 50A2_N5A; 'State' changed from 'Resolved' to 'Closed'.Incident
18407​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 5:23Name is 29 Modems Offline ncfrc001cme - cable-mac 55 50A2_N5A; 'State' changed from 'Updated' to 'Resolved'.Incident
18407​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 5:23'Resolution Code' is 'Generic'.Incident
18407​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 5:22Name is 101 Modems Offline ncfrc001cme - cable-mac 50 53A1_F53|53A2_FC2; 'State' changed from 'Resolved' to 'Closed'.Incident
18405​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 5:22Name is 101 Modems Offline ncfrc001cme - cable-mac 50 53A1_F53|53A2_FC2; 'State' changed from 'Updated' to 'Resolved'.Incident
18405​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 5:22'Resolution Code' is 'Generic'.Incident
18405​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 5:21Name is 14 Modems Offline tntaz001cmh - CATV-MAC 16 DE26; 'State' changed from 'Updated' to 'Resolved'.IncidentIncident=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)IncidentIncident
Derrick McDonald7/30/2021 5:21'Resolution Code' is 'Generic'.IncidentIncident=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)IncidentIncident
Derrick McDonald7/30/2021 5:21'End time' is 'Jul 30 2021 - 5:21AM'.IncidentIncident=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)IncidentIncident
Derrick McDonald7/30/2021 5:21'Cause' is 'Recovered during investigation'.IncidentIncident=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)IncidentIncident
Derrick McDonald7/30/2021 5:21Comment added 'BBX shows 102/103 online. Monitoring for stability.'IncidentIncident=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)IncidentIncident
Derrick McDonald7/30/2021 5:20Name is 14 Modems Offline tntaz001cmh - CATV-MAC 16 DE26; 'Assignee' changed from 'NOC' to 'Derrick McDonald'.IncidentIncident=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)IncidentIncident
Eric Cookson7/30/2021 5:19Comment added 'Power outage has been resolved modems still showing down as the spans are still down and are currently under repair. ETR for spans being fixed is 08:00 EST.'Incident
18397​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageHard Down
Eric Cookson7/30/2021 5:19Add tags [ETR 08:00 EST]Incident
18397​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageHard Down
Eric Cookson7/30/2021 5:19Remove tags [ETR 06:00 EST]Incident
18397​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageHard Down
Eric Cookson7/30/2021 5:19Remove tags [commercial power]Incident
18397​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageHard Down
Eric Cookson7/30/2021 5:17Name is 24 Modems Offline scgre003cme - cable-mac 36 CMAC-36; 'Subcategory' changed from 'Commercial Power' to 'Hard Down'.; 'Action Taken' changed from 'Verified outage checked commercial power ' to 'Commercial power resolved tech have'.; 'Cause' is '4 spans are down'.Incident
18397​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageHard Down
Derrick McDonald7/30/2021 5:10Comment added ''IncidentIncident=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)IncidentIncident
Derrick McDonald7/30/2021 5:10File image.png uploadedIncidentIncident=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)IncidentIncident
Derrick McDonald7/30/2021 5:10File image.png uploadedIncidentIncident=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)IncidentIncident
Derrick McDonald7/30/2021 5:10Name is 14 Modems Offline tntaz001cmh - CATV-MAC 16 DE26; 'Assignee' changed from 'NOC' to 'Derrick McDonald'.IncidentIncident=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)IncidentIncident
Derrick McDonald7/30/2021 5:10Name is 14 Modems Offline tntaz001cmh - CATV-MAC 16 DE26; 'Category' changed from 'Network Performance' to 'Network Outage'.; 'Subcategory' changed from 'Node Unresponsive' to 'Hard Down'.; 'Region' is 'Southeast'.; 'City' is 'NewTazewell TN'.; 'Address/Node' is 'DE26'.; 'Time Detected' is 'Jul 30 2021 - 4:47AM'.; 'Start Time' is 'Jul 30 2021 - 4:47AM'.; 'Impacted Customers' is '16'.; 'Total Customers on Node' is '102'.; 'Outage Type' is 'Unplanned'.; 'Services' is 'All'.; 'Effects' is 'No service'.; 'Action Taken' is 'Verified Commercial Power'.; 'Time Zone' is 'Central Time'.IncidentIncident=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)IncidentIncident
Derrick McDonald7/30/2021 5:08Comment added 'No reported outages at the moment though a large storm is passing through and it may not be safe to dispatch at this moment.'IncidentIncident=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)IncidentIncident
Derrick McDonald7/30/2021 5:07Name is 14 Modems Offline tntaz001cmh - CATV-MAC 16 DE26; 'Assignee' changed from 'NOC' to 'Derrick McDonald'.IncidentIncident=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)IncidentIncident
Eric Cookson7/30/2021 5:05Name is 22 Modems Offline scsen002cme - cable-mac 22 CMAC-22; 'Assignee' changed from 'NOC' to 'Eric Cookson'.Incident
18417​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 5:04Comment added 'Cumberland Gap'IncidentIncident=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)IncidentIncident
Derrick McDonald7/30/2021 5:04File image.png uploadedIncidentIncident=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)IncidentIncident
Derrick McDonald7/30/2021 5:04File image.png uploadedIncidentIncident=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)IncidentIncident
Derrick McDonald7/30/2021 5:04Name is 14 Modems Offline tntaz001cmh - CATV-MAC 16 DE26; 'Assignee' changed from 'NOC' to 'Derrick McDonald'.IncidentIncident=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)IncidentIncident
Derrick McDonald7/30/2021 5:03Comment added 'BBX shows 85/102 online. Checking power.'IncidentIncident=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)IncidentIncident
Derrick McDonald7/30/2021 5:01Name is 14 Modems Offline tntaz001cmh - CATV-MAC 16 DE26; 'State' changed from 'Pending Assignment' to 'Assigned'.; 'Assignee' changed from 'Network Operations Center' to 'Derrick McDonald'.IncidentIncident=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)IncidentIncident
Eric Cookson7/30/2021 4:57Name is Master - daltxfh1dw1 <Windstream CID: WS/KGUS/800979//WXN > menar001dw1 - Down; 'State' changed from 'Updated' to 'Resolved'.Incident
18152​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network Interface/CircuitDown
Eric Cookson7/30/2021 4:57'Resolution Code' is 'Generic'.Incident
18152​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network Interface/CircuitDown
Eric Cookson7/30/2021 4:57Comment added 'Latest update from Windstream indicates this has been resolved. menar001dw1 is back up. Customer: VYVE BROADBAND A LLC Circuit ID: WS/KGUS/800979/ /WXN / Trouble Ticket#: INC000048458029 Customer Ticket#: 18152 Reported By: Vyve Vyve Phone: Status: Referred Date: 07/29/21 15:58:39 Description: Vyve Preferred Contact: Phone 87744019889 noc@vyveebb.com TT 18152. John reports 10GB WS/KGUS/800979/ /WXN / Data Down on 7/29/2021 at 2:08:46 PM CT. Circuit has worked before. Access: 24/7 Intrusive=Y Power=Y. Advised dispatch charges may apply. CNOC at 844-946-2662. All Devices: N/A Worklog Update: Greetings Valued Windstream Customer Your trouble ticket that has been associated with a higher-level ticket impacting the Windstream Network has been RESOLVED. Troubleshooting Steps Taken: Referred to TNOC Resolution: LEC is now hands off. Splice enclosure is secured. TNOC has confirmed that services are restored. If your service has not restored or if you have questions...Incident
18152​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network Interface/CircuitDown
Eric Cookson7/30/2021 4:54Name is Master - daltxfh1dw1 <Windstream CID: WS/KGUS/800979//WXN > menar001dw1 - Down; 'State' changed from 'Pending Assignment' to 'Assigned'.; 'Assignee' changed from 'Network Operations Center' to 'Eric Cookson'.Incident
18152​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network Interface/CircuitDown
Eric Cookson7/30/2021 4:44Name is 10 Modems Offline lawlk001cmh - CATV-MAC 17 Welsh3(); 'State' changed from 'Resolved' to 'Closed'.Incident
18422​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Eric Cookson7/30/2021 4:44Name is 10 Modems Offline lawlk001cmh - CATV-MAC 17 Welsh3(); 'State' changed from 'Updated' to 'Resolved'.Incident
18422​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Eric Cookson7/30/2021 4:44'Resolution Code' is 'Generic'.Incident
18422​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Eric Cookson7/30/2021 4:44Comment added 'BBX shows 70/72 modems are currently online this has recovered.'Incident
18422​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Eric Cookson7/30/2021 4:44Name is 10 Modems Offline lawlk001cmh - CATV-MAC 17 Welsh3(); 'Assignee' changed from 'NOC' to 'Eric Cookson'.Incident
18422​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Eric Cookson7/30/2021 4:40Name is 92 Modems Offline scgre003cme - cable-mac 23 CMAC-23; 'State' changed from 'Updated' to 'Resolved'.Incident
18410​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageHard Down
Eric Cookson7/30/2021 4:40'Resolution Code' is 'Generic'.Incident
18410​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageHard Down
Eric Cookson7/30/2021 4:40Comment added 'Modems have recovered Called Charles back to get the cause and it was a tripped breaker.'Incident
18410​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageHard Down
Eric Cookson7/30/2021 4:38'Cause' changed from 'TBD' to 'Tripped Breaker'.Incident
18410​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageHard Down
Eric Cookson7/30/2021 4:36'Time Dispatched' is 'Jul 30 2021 - 3:01AM'.Incident
18410​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageHard Down
Eric Cookson7/30/2021 4:35'End time' is 'Jul 30 2021 - 5:32AM'.Incident
18410​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageHard Down
Eric Cookson7/30/2021 4:34Name is 92 Modems Offline scgre003cme - cable-mac 23 CMAC-23; 'Assignee' changed from 'Derrick McDonald' to 'Eric Cookson'.Incident
18410​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageHard Down
Derrick McDonald7/30/2021 4:28Name is Interface GigabitEthernet4/6 ----- SonicWall ----- is down - camts001rtc; 'State' changed from 'Resolved' to 'Closed'.Incident
18401​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Networking
18401​
Derrick McDonald7/30/2021 4:28Name is Interface GigabitEthernet4/6 ----- SonicWall ----- is down - camts001rtc; 'State' changed from 'Pending Assignment' to 'Resolved'.Incident
18401​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Networking
18401​
Derrick McDonald7/30/2021 4:28'Resolution Code' is 'Generic'.Incident
18401​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Networking
18401​
Derrick McDonald7/30/2021 4:27Name is 10 Modems Offline lawlk001cmh - CATV-MAC 17 Welsh3(); 'Assignee' changed from 'NOC' to 'Derrick McDonald'.Incident
18422​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Eric Cookson7/30/2021 4:27Comment added 'Checking this'Incident
18422​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Eric Cookson7/30/2021 4:26Name is 10 Modems Offline lawlk001cmh - CATV-MAC 17 Welsh3(); 'State' changed from 'Pending Assignment' to 'Assigned'.; 'Assignee' changed from 'Network Operations Center' to 'Eric Cookson'.Incident
18422​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 4:24Comment added 'Hugh Mundy on site and is working.'Incident
18410​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageHard Down
Derrick McDonald7/30/2021 4:24Name is 92 Modems Offline scgre003cme - cable-mac 23 CMAC-23; 'Assignee' changed from 'NOC' to 'Derrick McDonald'.Incident
18410​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageHard Down
Derrick McDonald7/30/2021 4:23Comment added 'Brandon TOM Called - Outage in Edgefield SC has 4 spans of trunk down. Gathering additoinal resources for restoration. Very Tenative ETR 8:00 AM'Incident
18397​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageHard Down
Derrick McDonald7/30/2021 4:23Name is 24 Modems Offline scgre003cme - cable-mac 36 CMAC-36; 'Assignee' changed from 'NOC' to 'Derrick McDonald'.Incident
18397​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageHard Down
Derrick McDonald7/30/2021 4:17Name is Enterprise KS Temp @ UPS is 112*; Abilene CMTS to Enterprise Modems Offline (Power); 'State' changed from 'Resolved' to 'Closed'.Incident
18342​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageHard Down
Derrick McDonald7/30/2021 4:12Name is 77 Modems Offline scsen002cme - cable-mac 1 CMAC 1; 'State' changed from 'Resolved' to 'Closed'.Incident
18299​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageDegraded Service
Derrick McDonald7/30/2021 4:12Name is 77 Modems Offline scsen002cme - cable-mac 1 CMAC 1; 'State' changed from 'Recovered' to 'Resolved'.Incident
18299​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageDegraded Service
Derrick McDonald7/30/2021 4:12'End time' is 'Jul 29 2021 - 9:43PM'.Incident
18299​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network OutageDegraded Service
Derrick McDonald7/30/2021 4:09Name is 13 Modems Offline lawlk001cmh - CATV-MAC 7 WL21()WL22; 'State' changed from 'Resolved' to 'Closed'.Incident
18341​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 4:09Name is 13 Modems Offline lawlk001cmh - CATV-MAC 7 WL21()WL22; 'State' changed from 'Updated' to 'Resolved'.Incident
18341​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
Derrick McDonald7/30/2021 4:09Comment added 'Flapping. Currently holding at 187/189 online. Monitoring.'Incident
18341​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

navic

Active Member
Joined
Jun 14, 2015
Messages
340
Office Version
  1. 2013
Platform
  1. Windows
Manually entered expected results would be helpful.
Maybe I didn't understand you well, but here's a try.
In the 'J' column set the 'helper' data.
The formula in the 'J2' cell is below (copy down)
Code:
=CONCATENATE($A2,$B2,E2)
The formula below, paste into 'K2' cell (copy down)
Code:
=COUNTIF($J$2:$J2,$J2)-1
or
Code:
=COUNTIF($J$2:$J2,A2&B2&E2)-1
or reverse counting
Code:
=COUNTIF($J2:$J$100,A2&B2&E2)-1
 

Attachments

  • chadlaw32.png
    chadlaw32.png
    21.2 KB · Views: 3

chadlaw32

Board Regular
Joined
Jul 29, 2014
Messages
77
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
Sorry in your example rows 9, 10, 11, 12 Since the person, ticket and time are the same I would want column k to show three 0s and 1 for one of them basically counting all 4 as the same thing.
 

chadlaw32

Board Regular
Joined
Jul 29, 2014
Messages
77
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
Here is an example of what i am looking for
UserCreatedCommentTicket TypeTicket NumberLinkCategorySubcategory
Derrick McDonald7/30/2021 5:55Comment added 'Calling for update.'Incident
18144​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network Interface/CircuitDown
1​
Derrick McDonald7/30/2021 5:54Comment added '137/142 online. Monitoring.'Incident
18417​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
0​
Derrick McDonald7/30/2021 5:54Name is 22 Modems Offline scsen002cme - cable-mac 22 CMAC-22; 'Assignee' changed from 'NOC' to 'Derrick McDonald'.Incident
18417​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
1​
Derrick McDonald7/30/2021 5:48Name is 11 Modems Offline scsen002cme - cable-mac 15 CMAC-15; 'State' changed from 'Resolved' to 'Closed'.Incident
18425​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
0​
Derrick McDonald7/30/2021 5:48Name is 11 Modems Offline scsen002cme - cable-mac 15 CMAC-15; 'State' changed from 'Recovered' to 'Resolved'.Incident
18425​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
0​
Derrick McDonald7/30/2021 5:48'Resolution Code' is 'Generic'.Incident
18425​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
1​
Eric Cookson7/30/2021 5:44Name is 11 Modems Offline scsen002cme - cable-mac 15 CMAC-15; 'State' changed from 'Pending Assignment' to 'Recovered'.Incident
18425​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
1​
Eric Cookson7/30/2021 5:43Name is 24 Modems Offline waeph001cmj - CATV-MAC 3 3A17A1; 'State' changed from 'Resolved' to 'Closed'.Incident
18426​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
0​
Eric Cookson7/30/2021 5:43Name is 24 Modems Offline waeph001cmj - CATV-MAC 3 3A17A1; 'State' changed from 'Updated' to 'Resolved'.Incident
18426​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
0​
Eric Cookson7/30/2021 5:43'Resolution Code' is 'Generic'.Incident
18426​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
0​
Eric Cookson7/30/2021 5:43Comment added 'BBX showing 65/66 modems are online. Potential polling issue.'Incident
18426​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
0​
Eric Cookson7/30/2021 5:42Name is 24 Modems Offline waeph001cmj - CATV-MAC 3 3A17A1; 'Assignee' changed from 'NOC' to 'Eric Cookson'.Incident
18426​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
0​
Eric Cookson7/30/2021 5:39Comment added 'Checking'Incident
18426​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
0​
Eric Cookson7/30/2021 5:39Name is 24 Modems Offline waeph001cmj - CATV-MAC 3 3A17A1; 'State' changed from 'Pending Assignment' to 'Assigned'.; 'Assignee' changed from 'Network Operations Center' to 'Eric Cookson'.Incident
18426​
=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)Network PerformanceNode Unresponsive
1​
 

navic

Active Member
Joined
Jun 14, 2015
Messages
340
Office Version
  1. 2013
Platform
  1. Windows

ADVERTISEMENT

I would want column k to show three 0s and 1 for one of them basically counting all 4 as the same thing
How about
Code:
=IF(SUMPRODUCT(($A$2:$A2=A2)*($E$2:$E2=E2))>1,0,1)
 

chadlaw32

Board Regular
Joined
Jul 29, 2014
Messages
77
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
I think that works. I have never used that formula can you explain how it works? Just to help me understand so I can use it again if i need it in the future.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
65,616
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: combine or count data
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
 

chadlaw32

Board Regular
Joined
Jul 29, 2014
Messages
77
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
After doing some checking it is not taking the time into account if you touch a ticket then come back an hour later and do it again each one of those should get a 1.
 

navic

Active Member
Joined
Jun 14, 2015
Messages
340
Office Version
  1. 2013
Platform
  1. Windows
How about
Formula in the helper column 'J2' as follows
Code:
=CONCATENATE($A2,$E2)
Formula in the 'K2' as follows
Code:
=IF(IF($J2=0,1,IF($J2=$J1,ROW(A1),1))<2,1,0)
 

Attachments

  • chadlaw32-2.png
    chadlaw32-2.png
    21.5 KB · Views: 2

chadlaw32

Board Regular
Joined
Jul 29, 2014
Messages
77
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
That is not working the date into the formula either so it is counting some tickets more then once. Rows 16 and 22 are counting even though it is the same ticket touched 3 minutes apart by the same person. If the same ticket is touched by the same person multiple times with in 10 minutes i want that to only count once. You are getting closer then I am so far.
How about
Formula in the helper column 'J2' as follows
Code:
=CONCATENATE($A2,$E2)
Formula in the 'K2' as follows
Code:
=IF(IF($J2=0,1,IF($J2=$J1,ROW(A1),1))<2,1,0)
 

Forum statistics

Threads
1,147,568
Messages
5,741,874
Members
423,692
Latest member
Bhanu1988

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top