AntBlabby8
Board Regular
- Joined
- Apr 18, 2002
- Messages
- 197
I need to count the number of unique occurrences in a column that is more than five hundred rows. I often do this by creating a simple pivot table the rows of which I count for my #, but as easy as it is, it's still a bit more work than seems necessary just to come up with a number. I have now found this formula for doing it, in a zillion places on the Net, including here on Mr. Excel. The problem is, I don't understand it. What exactly is this saying...The part I really don't get is the Apersand in the Countif. It must be something I haven't yet learned. Can someone repeat this formula in English, so to speak?
=SUMPRODUCT((A1:A10<>"")/COUNTIF(A1:A10,A1:A10&""))
Thanks, as usual. My entire non-basic knowledge of Excel comes from this website I think!
=SUMPRODUCT((A1:A10<>"")/COUNTIF(A1:A10,A1:A10&""))
Thanks, as usual. My entire non-basic knowledge of Excel comes from this website I think!