|
| 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 25th, 2005, 10:53 PM
|
|||
|
|||
Count Unique Names in list w/ Additional Criteria?
I have been able to use the formula below to count the "unique" company names
in list, but also wanted to use additional criteria such as Unique company names where state = TX (separate column).... what would the syntax be? is this possible?. =SUMPRODUCT(1/(COUNTIF(Company_Name,Company_Name)+(Company_Name= ""))) 
|
|
#2
January 25th, 2005, 11:15 PM
|
|||
|
|||
|
You could use the FREQUENCY method to count unique items
based on 1 or more criteria. George Simms posted a simple example a long time ago: http://tinyurl.com/3pkqr HTH Jason Atlanta, GA -----Original Message----- I have been able to use the formula below to count the "unique" company names in list, but also wanted to use additional criteria such as Unique company names where state = TX (separate column).... what would the syntax be? is this possible?. =SUMPRODUCT(1/(COUNTIF(Company_Name,Company_Name)+ (Company_Name=""))) .
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Pivot Table Access 2000? | Air-ron | General Discussion | 2 | October 29th, 2004 06:19 PM |
| List Boxes for Criteria | Matthew Ellis | New Users | 1 | September 17th, 2004 11:23 PM |
| LIST unique values | James Gilbert | Worksheet Functions | 3 | May 31st, 2004 11:16 AM |
| How to make list of unique values? | JulieD | Worksheet Functions | 1 | February 26th, 2004 12:25 PM |
Linear Mode
