Distinct
 

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...et.f unctions

Distinct
 

This will count unique (distinct) entries in the range A1:A10:

=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))

Biff

"Vipul Dani" wrote in message
...
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...et.f unctions

Distinct
 

OT: Biff, I've responded to your query in the thread Combin in this
newsgroup
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Distinct
 

"Max" wrote in message
...
OT: Biff, I've responded to your query in the thread Combin in this
newsgroup

Yes, I've seen it.

30 min calc times isn't too bad considering what it does!

Biff

Distinct
 

"Biff" wrote:
Yes, I've seen it.

well .. I won't know that unless you responded somewhere, would I ? <g

30 min calc times isn't too bad considering what it does!

Agreed. The time taken to generate all the combinations would vary depending
on the PC's specs, etc.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---