Hi, I'm trying to make a list as below. It has 3 columns Sr. No. Employee id and Name. Employee ID is looked up from another file and when Employee Name is entered, the employee ID from the list is displayed in the column. If the employee is new, then NEW is mentioned under employee ID.
We have several departments and employees may be shifted from one department to another and as such same employee name may appear more than once in the sheet.
What I am trying to do is get a summary of the NEW members (UNIQUE LIST) each month displayed at the end.
Currently I am using Countif function but this is not giving the desired results as there is duplication of names (as you can see from the below, it is not working properly and duplicates are also being counted together.)
Please advise a suitable solution. Many thanks
Sr. No. Emp. Id Name
Section1 - Primary
1 25 John
2 57 Bradley
3 85 Mike
4 97 Tom
Section2 - Secondary
1 85 Mike
2 67 Hulk
3 99 Dram
4 154 Sman
5 NEW Salman
6 25 John
7 NEW Paris
Section3 - Junior
1 67 Hulk
2 NEW Salman
3 NEW Paris
4 99 Dram
NEW 4
Bookmarks