Hello!

I am trying to count the number of unique values in a variable length column in the raw data worksheet. I can do this manually but would want to make it such that the results table auto-populates after I paste the data into the raw data worksheet.

What I have now counts the number of unique values in a defined column length, but doesn't work well for variable length columns --> =sumproduct(1/countif(a1:a10,a1:a10)) ... In this example, it is a column of length 10.

Any ideas appreciated.