we have a database about 30,000 line items which has 3 columns i.e., date, employee no and one column for (breakfast, lunch and dinner). Now if our employee use twice breakfast, lunch or dinner we want to know which employee have twice or single. As you know each employee is only allowed once each meal not twice. If his card is punched or manual entry. The database is maintained anyhow if he used twice also.
Please help me easy formula or Array formula which give me a list of employees who used more than once each meal. Thanks for help.