Hi guys,
I've looked all over for a solution to my problem and can't seem to get any to work. I have a spreadsheet that has a very large amount of information. What I'm trying to do is to count the number of unique items (techs) by month from a sheet that is composed of raw data (exported from a website and pasted in to excel).
Example: my worksheet is broken down by months, and i want to count the number of "unique" technicians working in that month. currently my spreadsheet raw data has over 120,000 rows and counting.
Here's what I had:
I've attached an abridged version of my spreadsheet in the hopes that someone can provide some advice.Please Login or Register to view this content.
Cut-Down.xlsm
Cheers
Bookmarks