jamesraywebber
New Member
- Joined
- Nov 20, 2017
- Messages
- 15
I have a workbook with 7 worksheets (2 are data connections).
Worksheet = TSA Daily
Worksheet = TSA Support (Data Connection)
I need on TSA Daily in cell A23 to search through the Associate column on TSA Support on the date on TSA Daily cell B1 and if the associates name appears more than twice to put their name. I have the formula in B23 to count how many times that name appears.
This is Worksheet = TSA Support (Data Connection)
[TABLE="width: 740"]
<tbody>[TR]
[TD]Date/Time
[/TD]
[TD]Time of Day
[/TD]
[TD]Team Support Associate
[/TD]
[TD]Customer Number
[/TD]
[TD]Associate
[/TD]
[/TR]
[TR]
[TD]12/12/2017 10:00
[/TD]
[TD]Morning (8a - 130p)
[/TD]
[TD]Ashley Velez-Garcia
[/TD]
[TD]133,445,404
[/TD]
[TD]Kristen Cooper
[/TD]
[/TR]
[TR]
[TD]12/12/2017 10:00
[/TD]
[TD]Morning (8a - 130p)
[/TD]
[TD]Ashley Velez-Garcia
[/TD]
[TD]133,605,163
[/TD]
[TD]Shaudia McCloud
[/TD]
[/TR]
[TR]
[TD]12/12/2017 10:00
[/TD]
[TD]Morning (8a - 130p)
[/TD]
[TD]Ashley Velez-Garcia
[/TD]
[TD]132,793,214
[/TD]
[TD]Edouard Morcos
[/TD]
[/TR]
[TR]
[TD]12/12/2017 10:00
[/TD]
[TD]Morning (8a - 130p)
[/TD]
[TD]Ashley Velez-Garcia
[/TD]
[TD]133,722,217
[/TD]
[TD]Travis Chase
[/TD]
[/TR]
[TR]
[TD]12/12/2017 10:00
[/TD]
[TD]Morning (8a - 130p)
[/TD]
[TD]Ashley Velez-Garcia
[/TD]
[TD]120,000,000
[/TD]
[TD]Rick Poppe
[/TD]
[/TR]
[TR]
[TD]12/12/2017 10:00
[/TD]
[TD]Morning (8a - 130p)
[/TD]
[TD]Ashley Velez-Garcia
[/TD]
[TD]134,286,159
[/TD]
[TD]Laura Robertson
[/TD]
[/TR]
[TR]
[TD]12/12/2017 10:00
[/TD]
[TD]Morning (8a - 130p)
[/TD]
[TD]Ashley Velez-Garcia
[/TD]
[TD]133,887,853
[/TD]
[TD]Kathleen Pearson
[/TD]
[/TR]
[TR]
[TD]12/11/2017 21:00
[/TD]
[TD]Evening (6p - 10p)
[/TD]
[TD]Kenya Brown
[/TD]
[TD]120,031,452
[/TD]
[TD]Mya Frazier
[/TD]
[/TR]
[TR]
[TD]12/11/2017 21:00
[/TD]
[TD]Evening (6p - 10p)
[/TD]
[TD]Dialo Lee
[/TD]
[TD]134,560,721
[/TD]
[TD]Diane LHeureux
[/TD]
[/TR]
[TR]
[TD]12/11/2017 20:00
[/TD]
[TD]Morning (8a - 130p)
[/TD]
[TD]Paul Toth
[/TD]
[TD]120,001,801
[/TD]
[TD]Roger Ogden
[/TD]
[/TR]
[TR]
[TD]12/11/2017 20:00
[/TD]
[TD]Evening (6p - 10p)
[/TD]
[TD]Kenya Brown
[/TD]
[TD]133,551,836
[/TD]
[TD]Memory Johnson
[/TD]
[/TR]
[TR]
[TD]12/11/2017 20:00
[/TD]
[TD]Evening (6p - 10p)
[/TD]
[TD]Kenya Brown
[/TD]
[TD]132,628,134
[/TD]
[TD]Marc Giordani
[/TD]
[/TR]
</tbody>[/TABLE]
And this is my Worksheet = TSA Daily
[TABLE="width: 1124"]
<tbody>[TR]
[TD]Date
[/TD]
[TD]12/12/2017
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Day
[/TD]
[TD]Tuesday
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Time of Day
[/TD]
[TD]Total Service Calls Handled
[/TD]
[TD]Triages Tickets Created
by TSA
[/TD]
[TD]Percentage of calls affected by Triage
[/TD]
[TD]Triages Tickets Created by ART
[/TD]
[TD]Triages Tciekts Created by Others
[/TD]
[TD]Total Triage Tickets Created
[/TD]
[TD]System/Citrix Issue - No Triage Ticket Created
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]8:00 - 9:00
[/TD]
[TD]139
[/TD]
[TD]1
[/TD]
[TD]0.72%
[/TD]
[TD]3
[/TD]
[TD]0
[/TD]
[TD]4
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]9:00 - 10:00
[/TD]
[TD]246
[/TD]
[TD]0
[/TD]
[TD]0.00%
[/TD]
[TD]19
[/TD]
[TD]0
[/TD]
[TD]19
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]10:00 - 11:00
[/TD]
[TD]315
[/TD]
[TD]0
[/TD]
[TD]0.00%
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]11:00 - 12:00
[/TD]
[TD]341
[/TD]
[TD]0
[/TD]
[TD]0.00%
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]12:00 - 1:00
[/TD]
[TD]343
[/TD]
[TD]0
[/TD]
[TD]0.00%
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]1:00 - 2:00
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]#DIV/0!
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]2:00 - 3:00
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]#DIV/0!
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]3:00 - 4:00
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]#DIV/0!
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]4:00 - 5:00
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]#DIV/0!
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]5:00 - 6:00
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]#DIV/0!
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]6:00 - 7:00
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]#DIV/0!
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]7:00 - 8:00
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]#DIV/0!
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]8:00 - 9:00
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]#DIV/0!
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]9:00 - 10:00
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]#DIV/0!
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]10:00 - 11:00
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]#DIV/0!
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Current Total
[/TD]
[TD]1384
[/TD]
[TD]1
[/TD]
[TD]0.07%
[/TD]
[TD]22
[/TD]
[TD]0
[/TD]
[TD]23
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]RTA Support
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Top Associates (Triage Tickets & System Issues)
[/TD]
[TD]
[/TD]
[TD="colspan: 6"]Daily Observations
[/TD]
[/TR]
[TR]
[TD](Formula)
[/TD]
[TD]=Countif(Associate,A23)
[/TD]
[TD]
[/TD]
[TD="colspan: 6"]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]
Worksheet = TSA Daily
Worksheet = TSA Support (Data Connection)
I need on TSA Daily in cell A23 to search through the Associate column on TSA Support on the date on TSA Daily cell B1 and if the associates name appears more than twice to put their name. I have the formula in B23 to count how many times that name appears.
This is Worksheet = TSA Support (Data Connection)
[TABLE="width: 740"]
<tbody>[TR]
[TD]Date/Time
[/TD]
[TD]Time of Day
[/TD]
[TD]Team Support Associate
[/TD]
[TD]Customer Number
[/TD]
[TD]Associate
[/TD]
[/TR]
[TR]
[TD]12/12/2017 10:00
[/TD]
[TD]Morning (8a - 130p)
[/TD]
[TD]Ashley Velez-Garcia
[/TD]
[TD]133,445,404
[/TD]
[TD]Kristen Cooper
[/TD]
[/TR]
[TR]
[TD]12/12/2017 10:00
[/TD]
[TD]Morning (8a - 130p)
[/TD]
[TD]Ashley Velez-Garcia
[/TD]
[TD]133,605,163
[/TD]
[TD]Shaudia McCloud
[/TD]
[/TR]
[TR]
[TD]12/12/2017 10:00
[/TD]
[TD]Morning (8a - 130p)
[/TD]
[TD]Ashley Velez-Garcia
[/TD]
[TD]132,793,214
[/TD]
[TD]Edouard Morcos
[/TD]
[/TR]
[TR]
[TD]12/12/2017 10:00
[/TD]
[TD]Morning (8a - 130p)
[/TD]
[TD]Ashley Velez-Garcia
[/TD]
[TD]133,722,217
[/TD]
[TD]Travis Chase
[/TD]
[/TR]
[TR]
[TD]12/12/2017 10:00
[/TD]
[TD]Morning (8a - 130p)
[/TD]
[TD]Ashley Velez-Garcia
[/TD]
[TD]120,000,000
[/TD]
[TD]Rick Poppe
[/TD]
[/TR]
[TR]
[TD]12/12/2017 10:00
[/TD]
[TD]Morning (8a - 130p)
[/TD]
[TD]Ashley Velez-Garcia
[/TD]
[TD]134,286,159
[/TD]
[TD]Laura Robertson
[/TD]
[/TR]
[TR]
[TD]12/12/2017 10:00
[/TD]
[TD]Morning (8a - 130p)
[/TD]
[TD]Ashley Velez-Garcia
[/TD]
[TD]133,887,853
[/TD]
[TD]Kathleen Pearson
[/TD]
[/TR]
[TR]
[TD]12/11/2017 21:00
[/TD]
[TD]Evening (6p - 10p)
[/TD]
[TD]Kenya Brown
[/TD]
[TD]120,031,452
[/TD]
[TD]Mya Frazier
[/TD]
[/TR]
[TR]
[TD]12/11/2017 21:00
[/TD]
[TD]Evening (6p - 10p)
[/TD]
[TD]Dialo Lee
[/TD]
[TD]134,560,721
[/TD]
[TD]Diane LHeureux
[/TD]
[/TR]
[TR]
[TD]12/11/2017 20:00
[/TD]
[TD]Morning (8a - 130p)
[/TD]
[TD]Paul Toth
[/TD]
[TD]120,001,801
[/TD]
[TD]Roger Ogden
[/TD]
[/TR]
[TR]
[TD]12/11/2017 20:00
[/TD]
[TD]Evening (6p - 10p)
[/TD]
[TD]Kenya Brown
[/TD]
[TD]133,551,836
[/TD]
[TD]Memory Johnson
[/TD]
[/TR]
[TR]
[TD]12/11/2017 20:00
[/TD]
[TD]Evening (6p - 10p)
[/TD]
[TD]Kenya Brown
[/TD]
[TD]132,628,134
[/TD]
[TD]Marc Giordani
[/TD]
[/TR]
</tbody>[/TABLE]
And this is my Worksheet = TSA Daily
[TABLE="width: 1124"]
<tbody>[TR]
[TD]Date
[/TD]
[TD]12/12/2017
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Day
[/TD]
[TD]Tuesday
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Time of Day
[/TD]
[TD]Total Service Calls Handled
[/TD]
[TD]Triages Tickets Created
by TSA
[/TD]
[TD]Percentage of calls affected by Triage
[/TD]
[TD]Triages Tickets Created by ART
[/TD]
[TD]Triages Tciekts Created by Others
[/TD]
[TD]Total Triage Tickets Created
[/TD]
[TD]System/Citrix Issue - No Triage Ticket Created
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]8:00 - 9:00
[/TD]
[TD]139
[/TD]
[TD]1
[/TD]
[TD]0.72%
[/TD]
[TD]3
[/TD]
[TD]0
[/TD]
[TD]4
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]9:00 - 10:00
[/TD]
[TD]246
[/TD]
[TD]0
[/TD]
[TD]0.00%
[/TD]
[TD]19
[/TD]
[TD]0
[/TD]
[TD]19
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]10:00 - 11:00
[/TD]
[TD]315
[/TD]
[TD]0
[/TD]
[TD]0.00%
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]11:00 - 12:00
[/TD]
[TD]341
[/TD]
[TD]0
[/TD]
[TD]0.00%
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]12:00 - 1:00
[/TD]
[TD]343
[/TD]
[TD]0
[/TD]
[TD]0.00%
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]1:00 - 2:00
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]#DIV/0!
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]2:00 - 3:00
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]#DIV/0!
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]3:00 - 4:00
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]#DIV/0!
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]4:00 - 5:00
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]#DIV/0!
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]5:00 - 6:00
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]#DIV/0!
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]6:00 - 7:00
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]#DIV/0!
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]7:00 - 8:00
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]#DIV/0!
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]8:00 - 9:00
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]#DIV/0!
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]9:00 - 10:00
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]#DIV/0!
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]10:00 - 11:00
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]#DIV/0!
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Current Total
[/TD]
[TD]1384
[/TD]
[TD]1
[/TD]
[TD]0.07%
[/TD]
[TD]22
[/TD]
[TD]0
[/TD]
[TD]23
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]RTA Support
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Top Associates (Triage Tickets & System Issues)
[/TD]
[TD]
[/TD]
[TD="colspan: 6"]Daily Observations
[/TD]
[/TR]
[TR]
[TD](Formula)
[/TD]
[TD]=Countif(Associate,A23)
[/TD]
[TD]
[/TD]
[TD="colspan: 6"]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]