Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting unique entries
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting unique entries
see previous post
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "DianeandChipps" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Unique Entries | Excel Discussion (Misc queries) | |||
Counting unique text entries in a filtered list... | Excel Worksheet Functions | |||
counting unique entries in a list | Excel Discussion (Misc queries) | |||
Counting Unique text entries in a sheet with a condition | Excel Worksheet Functions | |||
Counting unique entries in column A but only if specific values appear in columns B and C | Excel Worksheet Functions |