combine or count data

[chadlaw32]

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?

User	Created	Comment	Ticket Type	Ticket Number	Link	Category	Subcategory
Derrick McDonald	7/30/2021 5:55	Comment added 'Calling for update.'	Incident	18144​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Interface/Circuit	Down
Derrick McDonald	7/30/2021 5:54	Comment added '137/142 online. Monitoring.'	Incident	18417​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Performance	Node Unresponsive
Derrick McDonald	7/30/2021 5:54	Name 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 Performance	Node Unresponsive
Derrick McDonald	7/30/2021 5:48	Name 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 Performance	Node Unresponsive
Derrick McDonald	7/30/2021 5:48	Name 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 Performance	Node Unresponsive
Derrick McDonald	7/30/2021 5:48	'Resolution Code' is 'Generic'.	Incident	18425​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Performance	Node Unresponsive
Eric Cookson	7/30/2021 5:44	Name 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 Performance	Node Unresponsive
Eric Cookson	7/30/2021 5:43	Name 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 Performance	Node Unresponsive
Eric Cookson	7/30/2021 5:43	Name 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 Performance	Node Unresponsive
Eric Cookson	7/30/2021 5:43	'Resolution Code' is 'Generic'.	Incident	18426​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Performance	Node Unresponsive
Eric Cookson	7/30/2021 5:43	Comment added 'BBX showing 65/66 modems are online. Potential polling issue.'	Incident	18426​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Performance	Node Unresponsive
Eric Cookson	7/30/2021 5:42	Name 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 Performance	Node Unresponsive
Eric Cookson	7/30/2021 5:39	Comment added 'Checking'	Incident	18426​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Performance	Node Unresponsive
Eric Cookson	7/30/2021 5:39	Name 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 Performance	Node Unresponsive
Derrick McDonald	7/30/2021 5:38	Comment added 'Modems appear to be recovering. This appears to be flapping.'	Incident	18417​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Performance	Node Unresponsive
Derrick McDonald	7/30/2021 5:37	File image.png uploaded	Incident	18417​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Performance	Node Unresponsive
Derrick McDonald	7/30/2021 5:37	File image.png uploaded	Incident	18417​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Performance	Node Unresponsive
Derrick McDonald	7/30/2021 5:36	Comment added '111/142 showing online. Checking power.'	Incident	18417​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Performance	Node Unresponsive
Derrick McDonald	7/30/2021 5:36	Name 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 Performance	Node Unresponsive
Derrick McDonald	7/30/2021 5:36	Comment added '104/106 online. Monitoring.'	Incident	18425​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Performance	Node Unresponsive
Derrick McDonald	7/30/2021 5:35	Name 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 Performance	Node Unresponsive
Derrick McDonald	7/30/2021 5:35	Name 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 Performance	Node Unresponsive
Derrick McDonald	7/30/2021 5:34	Name 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 Outage	Commercial Power
Derrick McDonald	7/30/2021 5:33	Comment added ''	Incident	18424​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Outage	Commercial Power
Derrick McDonald	7/30/2021 5:33	File image.png uploaded	Incident	18424​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Outage	Commercial Power
Derrick McDonald	7/30/2021 5:33	File image.png uploaded	Incident	18424​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Outage	Commercial Power
Derrick McDonald	7/30/2021 5:33	Name 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 Outage	Commercial Power
Derrick McDonald	7/30/2021 5:30	Comment updated 'Liberty SC'	Incident	18424​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Outage	Commercial Power
Derrick McDonald	7/30/2021 5:30	Comment added ''	Incident	18424​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Outage	Commercial Power
Derrick McDonald	7/30/2021 5:30	File image.png uploaded	Incident	18424​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Outage	Commercial Power
Derrick McDonald	7/30/2021 5:30	File image.png uploaded	Incident	18424​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Outage	Commercial Power
Derrick McDonald	7/30/2021 5:30	Name 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 Outage	Commercial Power
Derrick McDonald	7/30/2021 5:29	Comment added '103/125 online per BBX. Checking power.'	Incident	18424​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Outage	Commercial Power
Derrick McDonald	7/30/2021 5:29	Name 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 Outage	Commercial Power
Derrick McDonald	7/30/2021 5:28	Comment added 'Checking validity'	Incident	18424​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Outage	Commercial Power
Derrick McDonald	7/30/2021 5:27	Name 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 Outage	Commercial Power
Derrick McDonald	7/30/2021 5:27	Name 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 Performance	Node Unresponsive
Derrick McDonald	7/30/2021 5:27	Name 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 Performance	Node Unresponsive
Derrick McDonald	7/30/2021 5:27	'Resolution Code' is 'Generic'.	Incident	18027​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Performance	Node Unresponsive
Derrick McDonald	7/30/2021 5:24	Comment added 'New ETR'	Incident	18406​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Outage	Commercial Power
Derrick McDonald	7/30/2021 5:24	File image.png uploaded	Incident	18406​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Outage	Commercial Power
Derrick McDonald	7/30/2021 5:24	File image.png uploaded	Incident	18406​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Outage	Commercial Power
Derrick McDonald	7/30/2021 5:24	Name 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 Outage	Commercial Power
Derrick McDonald	7/30/2021 5:23	Remove tags [Assignment Breach]	Incident	18406​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Outage	Commercial Power
Derrick McDonald	7/30/2021 5:23	Name 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 Performance	Node Unresponsive
Derrick McDonald	7/30/2021 5:23	Name 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 Performance	Node Unresponsive
Derrick McDonald	7/30/2021 5:23	'Resolution Code' is 'Generic'.	Incident	18404​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Performance	Node Unresponsive
Derrick McDonald	7/30/2021 5:23	Name 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 Performance	Node Unresponsive
Derrick McDonald	7/30/2021 5:23	Name 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 Performance	Node Unresponsive
Derrick McDonald	7/30/2021 5:23	'Resolution Code' is 'Generic'.	Incident	18407​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Performance	Node Unresponsive
Derrick McDonald	7/30/2021 5:22	Name 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 Performance	Node Unresponsive
Derrick McDonald	7/30/2021 5:22	Name 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 Performance	Node Unresponsive
Derrick McDonald	7/30/2021 5:22	'Resolution Code' is 'Generic'.	Incident	18405​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Performance	Node Unresponsive
Derrick McDonald	7/30/2021 5:21	Name is 14 Modems Offline tntaz001cmh - CATV-MAC 16 DE26; 'State' changed from 'Updated' to 'Resolved'.	Incident	Incident	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Incident	Incident
Derrick McDonald	7/30/2021 5:21	'Resolution Code' is 'Generic'.	Incident	Incident	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Incident	Incident
Derrick McDonald	7/30/2021 5:21	'End time' is 'Jul 30 2021 - 5:21AM'.	Incident	Incident	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Incident	Incident
Derrick McDonald	7/30/2021 5:21	'Cause' is 'Recovered during investigation'.	Incident	Incident	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Incident	Incident
Derrick McDonald	7/30/2021 5:21	Comment added 'BBX shows 102/103 online. Monitoring for stability.'	Incident	Incident	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Incident	Incident
Derrick McDonald	7/30/2021 5:20	Name is 14 Modems Offline tntaz001cmh - CATV-MAC 16 DE26; 'Assignee' changed from 'NOC' to 'Derrick McDonald'.	Incident	Incident	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Incident	Incident
Eric Cookson	7/30/2021 5:19	Comment 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 Outage	Hard Down
Eric Cookson	7/30/2021 5:19	Add tags [ETR 08:00 EST]	Incident	18397​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Outage	Hard Down
Eric Cookson	7/30/2021 5:19	Remove tags [ETR 06:00 EST]	Incident	18397​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Outage	Hard Down
Eric Cookson	7/30/2021 5:19	Remove tags [commercial power]	Incident	18397​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Outage	Hard Down
Eric Cookson	7/30/2021 5:17	Name 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 Outage	Hard Down
Derrick McDonald	7/30/2021 5:10	Comment added ''	Incident	Incident	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Incident	Incident
Derrick McDonald	7/30/2021 5:10	File image.png uploaded	Incident	Incident	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Incident	Incident
Derrick McDonald	7/30/2021 5:10	File image.png uploaded	Incident	Incident	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Incident	Incident
Derrick McDonald	7/30/2021 5:10	Name is 14 Modems Offline tntaz001cmh - CATV-MAC 16 DE26; 'Assignee' changed from 'NOC' to 'Derrick McDonald'.	Incident	Incident	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Incident	Incident
Derrick McDonald	7/30/2021 5:10	Name 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'.	Incident	Incident	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Incident	Incident
Derrick McDonald	7/30/2021 5:08	Comment 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.'	Incident	Incident	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Incident	Incident
Derrick McDonald	7/30/2021 5:07	Name is 14 Modems Offline tntaz001cmh - CATV-MAC 16 DE26; 'Assignee' changed from 'NOC' to 'Derrick McDonald'.	Incident	Incident	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Incident	Incident
Eric Cookson	7/30/2021 5:05	Name 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 Performance	Node Unresponsive
Derrick McDonald	7/30/2021 5:04	Comment added 'Cumberland Gap'	Incident	Incident	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Incident	Incident
Derrick McDonald	7/30/2021 5:04	File image.png uploaded	Incident	Incident	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Incident	Incident
Derrick McDonald	7/30/2021 5:04	File image.png uploaded	Incident	Incident	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Incident	Incident
Derrick McDonald	7/30/2021 5:04	Name is 14 Modems Offline tntaz001cmh - CATV-MAC 16 DE26; 'Assignee' changed from 'NOC' to 'Derrick McDonald'.	Incident	Incident	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Incident	Incident
Derrick McDonald	7/30/2021 5:03	Comment added 'BBX shows 85/102 online. Checking power.'	Incident	Incident	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Incident	Incident
Derrick McDonald	7/30/2021 5:01	Name 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'.	Incident	Incident	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Incident	Incident
Eric Cookson	7/30/2021 4:57	Name 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/Circuit	Down
Eric Cookson	7/30/2021 4:57	'Resolution Code' is 'Generic'.	Incident	18152​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Interface/Circuit	Down
Eric Cookson	7/30/2021 4:57	Comment 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/Circuit	Down
Eric Cookson	7/30/2021 4:54	Name 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/Circuit	Down
Eric Cookson	7/30/2021 4:44	Name 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 Performance	Node Unresponsive
Eric Cookson	7/30/2021 4:44	Name 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 Performance	Node Unresponsive
Eric Cookson	7/30/2021 4:44	'Resolution Code' is 'Generic'.	Incident	18422​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Performance	Node Unresponsive
Eric Cookson	7/30/2021 4:44	Comment added 'BBX shows 70/72 modems are currently online this has recovered.'	Incident	18422​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Performance	Node Unresponsive
Eric Cookson	7/30/2021 4:44	Name 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 Performance	Node Unresponsive
Eric Cookson	7/30/2021 4:40	Name 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 Outage	Hard Down
Eric Cookson	7/30/2021 4:40	'Resolution Code' is 'Generic'.	Incident	18410​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Outage	Hard Down
Eric Cookson	7/30/2021 4:40	Comment 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 Outage	Hard Down
Eric Cookson	7/30/2021 4:38	'Cause' changed from 'TBD' to 'Tripped Breaker'.	Incident	18410​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Outage	Hard Down
Eric Cookson	7/30/2021 4:36	'Time Dispatched' is 'Jul 30 2021 - 3:01AM'.	Incident	18410​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Outage	Hard Down
Eric Cookson	7/30/2021 4:35	'End time' is 'Jul 30 2021 - 5:32AM'.	Incident	18410​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Outage	Hard Down
Eric Cookson	7/30/2021 4:34	Name 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 Outage	Hard Down
Derrick McDonald	7/30/2021 4:28	Name 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 McDonald	7/30/2021 4:28	Name 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 McDonald	7/30/2021 4:28	'Resolution Code' is 'Generic'.	Incident	18401​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Networking	18401​
Derrick McDonald	7/30/2021 4:27	Name 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 Performance	Node Unresponsive
Eric Cookson	7/30/2021 4:27	Comment added 'Checking this'	Incident	18422​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Performance	Node Unresponsive
Eric Cookson	7/30/2021 4:26	Name 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 Performance	Node Unresponsive
Derrick McDonald	7/30/2021 4:24	Comment added 'Hugh Mundy on site and is working.'	Incident	18410​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Outage	Hard Down
Derrick McDonald	7/30/2021 4:24	Name 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 Outage	Hard Down
Derrick McDonald	7/30/2021 4:23	Comment 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 Outage	Hard Down
Derrick McDonald	7/30/2021 4:23	Name 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 Outage	Hard Down
Derrick McDonald	7/30/2021 4:17	Name 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 Outage	Hard Down
Derrick McDonald	7/30/2021 4:12	Name 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 Outage	Degraded Service
Derrick McDonald	7/30/2021 4:12	Name 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 Outage	Degraded Service
Derrick McDonald	7/30/2021 4:12	'End time' is 'Jul 29 2021 - 9:43PM'.	Incident	18299​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Outage	Degraded Service
Derrick McDonald	7/30/2021 4:09	Name 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 Performance	Node Unresponsive
Derrick McDonald	7/30/2021 4:09	Name 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 Performance	Node Unresponsive
Derrick McDonald	7/30/2021 4:09	Comment added 'Flapping. Currently holding at 187/189 online. Monitoring.'	Incident	18341​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Performance	Node Unresponsive

 

[navic]

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)

=CONCATENATE($A2,$B2,E2)

The formula below, paste into 'K2' cell (copy down)

=COUNTIF($J$2:$J2,$J2)-1

or

=COUNTIF($J$2:$J2,A2&B2&E2)-1

or reverse counting

=COUNTIF($J2:$J$100,A2&B2&E2)-1

 

[chadlaw32]

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]

Here is an example of what i am looking for

User	Created	Comment	Ticket Type	Ticket Number	Link	Category	Subcategory
Derrick McDonald	7/30/2021 5:55	Comment added 'Calling for update.'	Incident	18144​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Interface/Circuit	Down	1​
Derrick McDonald	7/30/2021 5:54	Comment added '137/142 online. Monitoring.'	Incident	18417​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Performance	Node Unresponsive	0​
Derrick McDonald	7/30/2021 5:54	Name 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 Performance	Node Unresponsive	1​
Derrick McDonald	7/30/2021 5:48	Name 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 Performance	Node Unresponsive	0​
Derrick McDonald	7/30/2021 5:48	Name 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 Performance	Node Unresponsive	0​
Derrick McDonald	7/30/2021 5:48	'Resolution Code' is 'Generic'.	Incident	18425​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Performance	Node Unresponsive	1​
Eric Cookson	7/30/2021 5:44	Name 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 Performance	Node Unresponsive	1​
Eric Cookson	7/30/2021 5:43	Name 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 Performance	Node Unresponsive	0​
Eric Cookson	7/30/2021 5:43	Name 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 Performance	Node Unresponsive	0​
Eric Cookson	7/30/2021 5:43	'Resolution Code' is 'Generic'.	Incident	18426​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Performance	Node Unresponsive	0​
Eric Cookson	7/30/2021 5:43	Comment added 'BBX showing 65/66 modems are online. Potential polling issue.'	Incident	18426​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Performance	Node Unresponsive	0​
Eric Cookson	7/30/2021 5:42	Name 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 Performance	Node Unresponsive	0​
Eric Cookson	7/30/2021 5:39	Comment added 'Checking'	Incident	18426​	=HYPERLINK(Sign into ServiceDesk by - SolarWinds Service Desk)	Network Performance	Node Unresponsive	0​
Eric Cookson	7/30/2021 5:39	Name 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 Performance	Node Unresponsive	1​

 

[navic]

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

=IF(SUMPRODUCT(($A$2:$A2=A2)*($E$2:$E2=E2))>1,0,1)

 

[chadlaw32]

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]

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]

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]

How about
Formula in the helper column 'J2' as follows

=CONCATENATE($A2,$E2)

Formula in the 'K2' as follows

=IF(IF($J2=0,1,IF($J2=$J1,ROW(A1),1))<2,1,0)

 

[chadlaw32]

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

=CONCATENATE($A2,$E2)

Formula in the 'K2' as follows

=IF(IF($J2=0,1,IF($J2=$J1,ROW(A1),1))<2,1,0)