Please see the attached workbook. This was an extremely complex issue that required the use of complex table calculations and domain padding. If you run into issues implementing this into your actual workbook. Let me know.
Thank you guys! sorry for late reply but this really working!!! At least with small amounts of data right now I am testing performance with 10M and sql database.
Anyway you helped me a lot! thanks