View original (French)

Count the number of unique values in 1 Excel column

Solved
Daniel -  
 JMPt31 -
How to count the number of different values (numbers and/or words) in the same EXCEL column?
These words and/or numbers may include:
- in column A: PRODUCTION, DEGRADE or DEPANNAGE
- in column B: CODE NUMBER in digits only
- in column C: VISSEUSE, CLE DEBRAYABLE or TOURNE-VIS
- in column D: P123456789, N987654321, Z000000000, P999999999, etc...
or empty cell
- in column E: N1E052, N1C2Q1, N5B0JX, etc...
or empty cell
- in column F: MONTER..., SERRER..., VISSAGE..., FIXER..., etc...
or empty cell
- in column G: 4, 8, 12, etc...
or empty cell
- in column H: 1PP1A99Z, 1PP2Z99A, etc...
or empty cell.

Thank you in advance for your help.
Daniel.

2 réponses

Réponse 1 / 2
Mike-31 Posted messages 18405 Registration date   Status Contributeur Last intervention   5 145
 
Hello,

you detail 8 columns from A to H and you want to count the values only once in one column, WHICH ONE!

an example of an array formula for a range column A
example from A2 to A50

=SUM(IF(A2:A50<>"",1/COUNTIF(A2:A50,A2:A50)))

Be careful, an array formula is confirmed by simultaneously pressing 3 keys on the keyboard Ctrl, Shift, and Enter
if you do it correctly, the formula will be enclosed in this kind of braces {}

--
A+
Mike-31

Not knowing is not a failure, failure is the refusal to learn.
17
FabienBOS
 
Simple and effective. Thank you!
0
Aline_9999
 
It's magical!!
0
JMPt31
 
Congratulations, it really helped me.
0