Distinct Count

[WillR]

Is there a formula that will give me a distinct count of a list of account numbers in excel..... i'm being a bit thick i know but it's thursday and we went to the pub for lunch....

 

[gareth]

Would you like to explain in more detail to me and i will be able to help you on this one my friend.

 

[gareth]

Would you like to explain in more detail to me and i will be able to help you on this one my friend.

 

[WillR]

I have a list of account numbers extracted from a database, some of which are duplicates....what i want to do is get a distinct count of the number of unique account numbers in the list....

 

[Aladin Akyurek]

On 2002-09-05 07:30, WillR wrote:
Is there a formula that will give me a distinct count of a list of account numbers in excel..... i'm being a bit thick i know but it's thursday and we went to the pub for lunch....

Let A2:A100 house the account numbers of interest.

Array-enter:

=SUM(IF(LEN(A2:A100),1/COUNTIF(A2:A100,A2:A100)))

To array-enter a formula, hit control+shift+enter at the same time, not just enter.

If you have the morefuncadd-in installed, use:

=COUNTDIFF(A2:A100)

which is normally entered.

 

[WillR]

Cheers Aladin....

Know anywhere i can get hold of the morefunc addin??

 

[Aladin Akyurek]

On 2002-09-05 08:59, WillR wrote:
Cheers Aladin....

Know anywhere i can get hold of the morefunc addin??

I thought you knew how to search this board...

http://longre.free.fr/english/index.html

 

[WillR]

Sorry... it's thursday and i was being a slob