Hello Fellow Excel Users,

Thanks for taking the time to read this.

I am using a simple COUNTIF function on a list of unique values. These values are strings. On another sheet in the same workbook, I have a another list of strings, but they are not unique. I want to see how many times each value on the unique sheet appears in the non-unique sheet using COUNTIF. The formula work fine but the unique sheet has 200,000 values and the non-unique sheet has a little over 1 million values. The COUNTIF calculation takes seriously forever...

Is there as faster way to do this or improve the speed of this process?

My computer runs Intel i5 with 6GB of RAM (not sure if this helps).

Thanks in advance!!

Sincerely,

Gray-ish