| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting Unique Values in A column
I need to count the unique (non-duplicate) values in a column range.
Does anybody know an Excel or VBA function to do this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Counting Unique Values in A column
=SUM(1/COUNTIF(A1:A1000,A1:A1000))
(Array Entered - CTRL+SHIFT+ENTER) or =SUM(N(FREQUENCY(A1:A1000,A1:A1000)0)) (Array Entered - CTRL+SHIFT+ENTER) (Numbers only in a mix of numbers & Text) -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP ---------------------------------------------------------------------------- Attitude - A little thing that makes a BIG difference ---------------------------------------------------------------------------- "ibeetb" wrote in message ... I need to count the unique (non-duplicate) values in a column range. Does anybody know an Excel or VBA function to do this? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Counting Unique Values in A column
See this page
http://www.cpearson.com/excel/duplic...CountingUnique -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "ibeetb" wrote in message ... I need to count the unique (non-duplicate) values in a column range. Does anybody know an Excel or VBA function to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting unique values in column | Excel Discussion (Misc queries) | |||
| Excel Pivot Table - Counting Unique Values within one column of da | Excel Worksheet Functions | |||
| Counting Unique Values That Are Separate by Commas in a Column | Excel Discussion (Misc queries) | |||
| Counting Unique Values | Excel Worksheet Functions | |||
| Counting unique entries in column A but only if specific values appear in columns B and C | Excel Worksheet Functions | |||
Linear Mode
