This will count unique (distinct) entries in the range A1:A10:
=SUMPRODUCT((A1:A10<>"")/COUNTIF(A1:A10,A1:A10&""))
Biff
"Vipul Dani" <[email protected]> wrote in message
news:[email protected]...
> Hello
>
> We have sum,max,min... etc so why we don,t have function like Distinct
> count, which is there in varios apllication like crystal reports
> --
> Vipul C Dani
> Assistant Training Manager
> Prgati Software Pvt Ltd.
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow
> this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...heet.functions
Bookmarks