| Home |
| Search |
| Today's Posts |
|
#11
|
|||
|
|||
"Bruce Norris" wrote...
.... I want a formula in another cell to count how many values (text) appear more than once in the range. So... - Values that appears only once in the list: Don't count. - Values that appears more than once in the list: Count the value as 1. - Blank cells: Don't count. .... Another alternative, =SUMPRODUCT((Rng<"")*(COUNTIF(Rng,Rng)1)/(COUNTIF(Rng,Rng)+(Rng=""))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MIN with zero values in the range | Excel Discussion (Misc queries) | |||
| Checking ALL values in a range | Excel Discussion (Misc queries) | |||
| How to move Y-axis values when X range is -a to +b | Charts and Charting in Excel | |||
| Counting values within a Date Range | Excel Discussion (Misc queries) | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
Threaded Mode
