# Counting unique values in a table column

1. ## Counting unique values in a table column

I have a table accounts "Account Numbers" and at the bottom of the table I would like to provide a value that shows the number of unique account numbers in the column. Please note that this is a table and not a list.

Account Number
0233
0233
0234
4432
4333
4432
4415
4415

I am using Excel 365 ProPlus. Is there a function I can place at the bottom of the column for this table that will count the number of unique account numbers? Would this function still work if the account numbers were filtered in some way (e.g. account numbers that only begin with the number 4,etc.?

Thanks in advance for the help with this!

MGTexas123

2. ## Re: Counting unique values in a table column

=SUM(1/COUNTIF(A3:A10,A3:A10)) array formula

3. Originally Posted by tim201110
=SUM(1/COUNTIF(A3:A10,A3:A10)) array formula
Thanks Tim for your help with this. Is there a way to do this without an array formula or cell references? Something like countif(1/(column header name in table)) ?

4. ## Re: Counting unique values in a table column

Try the following: =SUMPRODUCT(1/COUNTIF(Table1[Account Number],Table1[Account Number]))
Let us know if you have any questions.

5. ## Re: Counting unique values in a table column

You have Office 365. You should be able to enter this without CSE.
Formula:
`Please Login or Register  to view this content.`

There are currently 1 users browsing this thread. (0 members and 1 guests)