Counting unique entries


G

Guest

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.
 
Ad

Advertisements

B

Bob Phillips

see previous post

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top