Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count duplicate values in worksheet
Hi all,
does anyone knows how to write a formula to count the no. of duplicate vales in a column? For example: Yes No Yes No Yes When we apply the formula to a cell based on the value "Yes", the cell will show 3. When we apply the same formula in another cell, the cell value will show 2. The Count formula in Excel counts only numeric values. Any help is appreciated. Thanks in advance. Cheers, HS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I count once, multiple duplicate values? | Excel Worksheet Functions | |||
Count Duplicate Values | Excel Discussion (Misc queries) | |||
How to count duplicate or repeat values | Excel Discussion (Misc queries) | |||
Count on multiple values with duplicate rows | Excel Worksheet Functions | |||
How do I do count calculations ignoring duplicate values | Excel Discussion (Misc queries) |