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
 

navic

Active Member
Joined
Jun 14, 2015
Messages
340
Office Version
  1. 2013
Platform
  1. Windows
How about
Code:
=IF(COUNTIF($J$2:$J2,$J2)>1,0,IF(IF($J2=0,1,IF($J2=$J1,ROW(A1),1))<2,1,0))
If this doesn't help, please upload here a certain number of rows of your example ('A','B' and 'E' columns only) with showing more variants and entering manually expected results.
 

Attachments

  • chadlaw32-3.png
    chadlaw32-3.png
    21.9 KB · Views: 2

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

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 the results i wanting to get.
1628250778192.png
 

navic

Active Member
Joined
Jun 14, 2015
Messages
340
Office Version
  1. 2013
Platform
  1. Windows
Please upload data like in post #1 (not picture)
Or you can use xl2bb v.2.0
 

chadlaw32

Board Regular
Joined
Jul 29, 2014
Messages
77
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
Here ya go

UserCreatedTicket Number
Derrick McDonald7/30/2021 5:55
18144​
1
Derrick McDonald7/30/2021 5:54
18417​
1
Derrick McDonald7/30/2021 5:54
18417​
0
Derrick McDonald7/30/2021 5:48
18425​
1
Derrick McDonald7/30/2021 5:48
18425​
0
Derrick McDonald7/30/2021 5:48
18425​
0
Eric Cookson7/30/2021 5:44
18425​
1
Eric Cookson7/30/2021 5:43
18426​
1
Eric Cookson7/30/2021 5:43
18426​
0
Eric Cookson7/30/2021 5:43
18426​
0
Eric Cookson7/30/2021 5:43
18426​
0
Eric Cookson7/30/2021 5:42
18426​
0
Eric Cookson7/30/2021 5:39
18426​
0
Eric Cookson7/30/2021 5:39
18426​
0
Derrick McDonald7/30/2021 5:38
18417​
1
Derrick McDonald7/30/2021 5:37
18417​
0
Derrick McDonald7/30/2021 5:37
18417​
0
Derrick McDonald7/30/2021 5:36
18417​
0
Derrick McDonald7/30/2021 5:36
18425​
1
Derrick McDonald7/30/2021 5:36
18425​
0
Derrick McDonald7/30/2021 5:35
18417​
1
Derrick McDonald7/30/2021 5:35
18425​
0
 

chadlaw32

Board Regular
Joined
Jul 29, 2014
Messages
77
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
you can switch the order to where the earliest or the latest gets the 1 but you should only get a 1 once per 10 minutes on the same ticket by the same person
 

navic

Active Member
Joined
Jun 14, 2015
Messages
340
Office Version
  1. 2013
Platform
  1. Windows
Why is result 1 expected in Row22, if the request is “within 10 minutes”.
So break is every 10 minutes (for 3 same conditions)
There are 3 same conditions: user, date/time and ticket.
If you subtract time in Row16 - Row22 the result is 3 minutes?

- Row16 -> 5:38 (h:min)
- Row22 -> 5:35 (h:min)
- 5:38 - 5:35 = 0:3 (h:min)

Sorry in my bad English!
 

Forum statistics

Threads
1,147,574
Messages
5,741,901
Members
423,693
Latest member
Excelquestion35

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