Hello,
We know that to count unique occurances of numbers (part numbers in this case) in a column we can say:
=SUM(IF(FREQUENCY(A21:A341, A21:A341)>0,1,0))
But what can we say when we want to know how many unique occurances of a text string (part names) there are in a similar range? (b21:b341)
We know that to count unique occurances of numbers (part numbers in this case) in a column we can say:
=SUM(IF(FREQUENCY(A21:A341, A21:A341)>0,1,0))
But what can we say when we want to know how many unique occurances of a text string (part names) there are in a similar range? (b21:b341)