I have a situation where I need to count the unique for a customer. The areas to be counted are separated by blank lines.
At present, I am using sumproduct(1/countif(range1,range1), to count the unique items. This formula works perfectly except that it takes me almost an hour to do this for all the measurements.
Is there a macro that can provide me with the same results -- putting the same values where I am presently have the formulas (the cells that before the blank lines)?
Thank you in advance for your help.
PS I had to take out the Bolded values and delete some lines to make have the appropriate file size. The length of the file is normally around 1073 lines.