| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Distinct
OT: Biff, I've responded to your query in the thread Combin in this
newsgroup -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get distinct rows from different worksheets into another worksheet | Excel Discussion (Misc queries) | |||
| distinct values in column | New Users to Excel | |||
| Sum Distinct Rows in PivotTable | Charts and Charting in Excel | |||
| is there a "distinct" function native to Excel | Excel Worksheet Functions | |||
| Dependant Droplist showing distinct records | Excel Worksheet Functions | |||
Linear Mode
