Distinct

's Computer Specifications

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

's Computer Specifications

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

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

Biff

"Vipul Dani" <(E-Mail Removed)> wrote in message
news:734D5C51-7546-4310-AF2E-(E-Mail Removed)...
> 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

's Computer Specifications

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

's Computer Specifications

"Max" <(E-Mail Removed)> wrote in message
news:E0D5F26C-AE24-4FE6-B80A-(E-Mail Removed)...
> OT: Biff, I've responded to your query in the thread Re: Combin in this
> newsgroup

Yes, I've seen it.

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

Biff

's Computer Specifications

"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
---

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
get distinct data from multiple sheets & then consolidate distinct	=?Utf-8?B?TmlraGls?=	Microsoft Excel Programming	1	18th Sep 2006 07:01 PM
distinct??	=?Utf-8?B?cmh5cw==?=	Microsoft Access	3	3rd Mar 2006 09:45 AM
uses select statement with both distinct and not distinct	=?Utf-8?B?VGhlbGVlcGFu?=	Microsoft Access Queries	1	8th Dec 2005 12:27 AM
Use of Distinct?	=?Utf-8?B?d2dvbGRmYXJi?=	Microsoft Access Queries	3	7th Sep 2005 03:54 PM
Distinct query not producing distinct results	KarenM	Microsoft Access	1	26th May 2004 07:41 PM