|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 26th, 2005, 08:55 PM
|
|||
|
|||
count a group of numbers but do not count duplicates
I need to count a column of numbers but do not want to count the duplicate
numbers. How do I do this? 
|
|
#2
January 26th, 2005, 10:03 PM
|
|||
|
|||
|
I'm not sure whether you want to count the number of unique entries or to sum
them. Assuming it's the former: =SUM(1/COUNTIF(A1:A20,A1:A20)) entered as an array formula with CTRL+SHIFT+ENTER If you want to sum the first occurrence of each unique number, use a "helper" column (say C) with this formula, copied down as far as needed. =COUNTIF($A$1:A1,A1) Then use =SUMIF(C1:C20,1,A1:A20) On Wed, 26 Jan 2005 12:55:05 -0800, Lisaml wrote: I need to count a column of numbers but do not want to count the duplicate numbers. How do I do this?
|
|
#3
January 26th, 2005, 11:19 PM
|
|||
|
|||
|
Try this: http://www.cpearson.com/excel/duplicat.htm
Look under "Counting Unique Entries In A Range" Ola Sandstrom
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How count without duplicates in higher group by sepcial condition? | chenr | Setting Up & Running Reports | 2 | January 10th, 2005 03:45 PM |
| Syntax needed to get needed reports | Frank Lueder | New Users | 15 | January 6th, 2005 08:39 AM |
| List Containing Instances of Numbers in a group | MrvinGover | Worksheet Functions | 1 | January 20th, 2004 06:27 PM |
Linear Mode
