Hello forum, I have a workbook we use to count inventory. My first issue which seems to be the biggest problem is that I am trying to find Unique values in a named range. The problem is that it is taking forever to run. I have 8 named ranges on each work sheet named ZONE_101, ZONE_102..... up to ZONE_108. It takes about 3 minutes for the value to be returned just for one range. Is there a better way to do this or a solution in VBA? I am using the following formula.I am not able to post the data I am using do to privacy restrictions, but each range is anywhere from 20k rows to 75k rows so the ranges are dynamically named. I will just post the formula for one range but I am doing it 8 times and adding the values together. 
=SUMPRODUCT((ZONE_101<>"")/COUNTIF(ZONE_101,ZONE_101&""))