I need help with a formula to count the unique values in two cells with comma separated values.

My data is like this in column A:

12,12,13,14,16,17,20

11,13,17,18,18,20

The expected result for these in column B1: 3

Note: The values in each comma-separated list all are positive but may contain duplicates.

I am open to a vba solution too. Thank you.

Also asked here Counting the common unique values between two comma-separated lists

My data is like this in column A:

12,12,13,14,16,17,20

11,13,17,18,18,20

The expected result for these in column B1: 3

Note: The values in each comma-separated list all are positive but may contain duplicates.

I am open to a vba solution too. Thank you.

Also asked here Counting the common unique values between two comma-separated lists

Last edited by a moderator: