The client wants the details of the employees that have an employee center license.
Solution
Download the roles of each employee.
From that excel identifies the employees who have only an employee center role. For that use “countif” function.
Eg:=COUNTIF(A:A,A2)>1
The file should be as follows.
This formula will show the true or false values. If it is false the employee has only one role. From this list sort the employees who have only employee center roles.
Note: If the employee has both an employee center and vendor center it will be considered an employee center.