| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Count unique entries
I have a list of 900 entries and for each change of code in column B I need
to know the number of publications used in D excluding the duplication, ie for ABCABC there are 3 publications, for ABCDDD there are 4. A B C D ABC ABCABC A MELAGE ABC ABCABC A MELAGE ABC ABCABC A MELHER ABC ABCABC A DOGHAN ABC ABCDDD A MELAGE ABC ABCDDD A MELAGE ABC ABCDDD A SYDMOR ABC ABCDDD A MELHER ABC ABCDDD A BRICOU In a separate area I will then have a list of B codes with the formula next to it that calculates the number of unique publications eg: ABCABC 3 ABCDDD 4 Any help with the formula I should use would be greatly appreciated. -- Thank for your help BeSmart |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "COUNTU" function in Excel to count unique entries in a range | Excel Worksheet Functions | |||
| Table to pick out most common entries and count occurences of each | Excel Worksheet Functions | |||
| Count of unique entries | Excel Discussion (Misc queries) | |||
| how to count unique entries with multiple condition | Excel Worksheet Functions | |||
| count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
Threaded Mode
