Count the number of unique values in 1 Excel column
Solved
Daniel
-
JMPt31 -
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.
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 answers
-
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.
