| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Numbers Only Once in a Range
Does anyone know a formula that counts numbers in a range only once when they
appear. For example: Range includes 1.34 three times, 0.80 five times, and 0.27 15 times. The count formula counts the range 23 times rather than the 3 times I am looking for. Any help is greatly appreciated. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count the cell contain a specific numbers in a range | Excel Discussion (Misc queries) | |||
| Count unique numbers in a range with a given criteria | Excel Discussion (Misc queries) | |||
| Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
| get a count of numbers whose value falls within a given range | Excel Worksheet Functions | |||
| How do I count numbers in a range that are greater than and less . | Excel Worksheet Functions | |||
Threaded Mode
