| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unique number counting
I have used a formula from an earlier discussion to count the number of
unique number appearing between E2:E1000. =SUMPRODUCT((E2:E1000<"")/COUNTIF(E2:E1000,E2:E1000&"")) Column E being house numbers. I would now like to count how many entries between A2:A1000 =1. Column A is the number of days a repair is outstanding. The result would show the number of houses that had repairs outstanding. Each house can have a number of repairs each with a different number of days outstanding. Can anyone help me with this please? Many thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Filter unique random number | Excel Worksheet Functions | |||
| Match two tables using unique ID number | Excel Discussion (Misc queries) | |||
| Counting the number of cells meeting conditional formating criteria | Excel Worksheet Functions | |||
| Counting number of grades in a row | Excel Worksheet Functions | |||
Threaded Mode
