thereseexceljakubiak
New Member
Hi guys? can anyone suggest a faster formula to achieve this:
https://dl.dropboxusercontent.com/u/35552808/SAMPLE_chandoo.xls
So, essentially, i have a list that I need to compare to my master database. If those list of IDs exist in the database, count the number of times where their corresponding dates fall within a range.
I have three Sumproducts in my file right now and it slow my entire computer down. I essentially need at least 80,000 formulas... eek! I have a 80 data tables with 100 data cells in each.
The sample sheet explains a little better?
https://dl.dropboxusercontent.com/u/35552808/SAMPLE_chandoo.xls
So, essentially, i have a list that I need to compare to my master database. If those list of IDs exist in the database, count the number of times where their corresponding dates fall within a range.
I have three Sumproducts in my file right now and it slow my entire computer down. I essentially need at least 80,000 formulas... eek! I have a 80 data tables with 100 data cells in each.
The sample sheet explains a little better?