I am needing help to pull our specific employee's from my call data based on position.
I'd like a formula to say if the employee is in this list then code them as Sup otherwise code as CSR.
Sup list is
Brittany H
Alicia G
Lupita A
Nicoya W
I am needing help to pull our specific employee's from my call data based on position.
I'd like a formula to say if the employee is in this list then code them as Sup otherwise code as CSR.
Sup list is
Brittany H
Alicia G
Lupita A
Nicoya W
Try in Q2:
=IF(COUNTIF($A$2:$A$14,P2),"SUP","CSR")
This worked-- thank you Belinda200
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks