|
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? |
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? |
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? |
| All times are GMT +1. The time now is 10:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com