Hello everyone,

I need to know how many different values in an excel column and what are these names.

Example for;

Column1 Column2

A AN

B AZ

B AN

A AW

C AX

outputs:

Column1 has 3 different values: A,B,C

Column2 has 4 different values: AN,AZ,AW,AX

How can I find it? Is there any activity or anything for this? And how can ı use it?

Thanks.