Categories
Development User Help

Excel – How can I count unique emails per hourly interval per employee?

I would like to count unique emails that every employee received per interval. I’m using FREQUENCY and MATCH but I’m getting incorrect outputs. Please see the sample table below. Employee A gets 1 email at 08:00, 1 new email at 09:00 and so on. Thanks!

sample

Leave a Reply

Your email address will not be published. Required fields are marked *