1-I want to count the number of people entered without dupication in one day. Just are the date, not the exact time. Each person has a unique Badge number.
2-After that, I have another worksheet with all the empoyees` Badge number. I want to compare the peoople entered with this sheet to exclude the visitors, i.e. the people inside both sheets remain. Then count how many.