In the attached sample sheet I have entries that list User IDs, User names, Training attended and training status. Some of the users show duplication as they have attended both the training
1. How can I filter all the duplicates in to another sheet?
2. How can i filter only those users who have complete the refresher but the New Hire shows In progress?
Solved by M. H. in 17 mins