Hi Brian
I have a question for youPlease have a look at the screen shot I attached. I need to pull employees who have the same department and position in the whole table.For instance, Employee ID = 2 has the same department (c) and the same position (Admin) but employee ID = 1 changed the department and position. Also Employee ID = 3 is in the same department but changed the position. I am looking for such an Employee ID = 2
I do not know how to use criterias for such a probelm or write scripts
Thanks
Images:
This is simple. Perform a summary by Employee ID, Department and Position. Any transactions that only have 1 as the number of records would be an employee that has the same department and position. So in your scenarion employe 1 would have two transactions, employe 2 would have 1 and employe 3 would have 2. Then just do a criteria for the number of records = 1 to get the employees you are looking for. If you need all the transactions then just do a join back to the original files of the employees with one record.
Hopefuly this makes sense.