| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting Unique Values
Thanks very much for your help, got it to work!
"Chip Pearson" wrote: I forgot to mention that this is an Array Formula. Therefore, you must press CTRL SHIFT ENTER rather than just ENTER when you first enter the formula and whenever you edit it later. If you do this properly, Excel will display the formula in the formula bar enclosed in curly braces { }. For more about array formulas, see http://www.cpearson.com/Excel/ArrayFormulas.aspx -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "LaDdIe" wrote in message ... Thanks Chip, The results is an error (a value used in the formula is of the wrong data type). Would you be able to help resolve this? Thanks. Laddie "Chip Pearson" wrote: Try the following in D15: =SUM(IF(FREQUENCY(IF(LEN(D1:D14)0,MATCH(D1:D14,D1 :D14,0),""), IF(LEN(D1:D14)0,MATCH(D1:D14,D1:D14,0),""))0,1)) -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "LaDdIe" wrote in message ... Hiya, Cells D1:D14 contain values Numerical & Text, and may appear more than once in this range, I would like a way to count cells with values (ignoring blank cells) and ignoring duplicate values, the result to be displayed in D15, VBA or Formula. I've attemped to search around the discussion pages for somthing to modify w/o luck. Thanks Laddie. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting unique values | Excel Worksheet Functions | |||
| Counting unique values | Excel Discussion (Misc queries) | |||
| Counting Unique Values | Excel Discussion (Misc queries) | |||
| Counting unique values | Excel Discussion (Misc queries) | |||
| Counting unique values | Excel Worksheet Functions | |||
Threaded Mode
