I am trying to create a specialized daily report. I need help based on the following workbook. Sheet 1 my data, sheet 2 has a list of all the numbers (column a) that I need to do a reference to from sheet 1.
I need the following results.
1. Remove the duplicates from column B in sheet 1 based on a hourly basis. We find this on column A.
2. Count in sheet 1 how many numbers are left minus duplication per hour.
A sample of what I am looking for is on sheet 3
I know how to manually do this but I want to create formula or macro to help.
Thanks for this
Bookmarks