# Distinct Count

#### WillR

##### Well-known Member
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....

### Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Would you like to explain in more detail to me and i will be able to help you on this one my friend.

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

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

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.

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

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

Replies
2
Views
183
Replies
4
Views
427
Replies
2
Views
366
Replies
8
Views
617
Replies
4
Views
385

1,219,798
Messages
6,150,318
Members
450,951
Latest member
kh198

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back