| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I count a row of NON-duplicate entries in Excell?
I'm using Excell. I have a row of numbers, some of which repeat. I want to
count how many unique numbers I have, thus eliminating duplicates. What formula and criteria do I use? Ex: 2 34 5 26 77 8 91 42 3 26 1 77 50 26 In the above example, the correct answer should be 11 since I want to count 26 and 77 only once. |
|
#2
|
|||
|
|||
|
=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))
-- HTH Bob Phillips "needhelp" wrote in message ... I'm using Excell. I have a row of numbers, some of which repeat. I want to count how many unique numbers I have, thus eliminating duplicates. What formula and criteria do I use? Ex: 2 34 5 26 77 8 91 42 3 26 1 77 50 26 In the above example, the correct answer should be 11 since I want to count 26 and 77 only once. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
| Preventing Duplicate Entries within a column | Excel Discussion (Misc queries) | |||
| count data but avoid double entries | Excel Worksheet Functions | |||
| Add numbers for duplicate entries then delete | Excel Worksheet Functions | |||
| get count of row without duplicate entries | Excel Worksheet Functions | |||
Linear Mode
