# Count unique value in series of data

#### jusho

##### New Member
Hello guys, i have a question. I need to count unique value in series of data.

Example in column B i have :
123
234
123
234
234

So i need a way to make the formula count result is 2. Because its contain only 123 and 234 but it duplicates.
How can i make that? if i use =count its result 5. I have you count until 1 million raw per day, its confused me

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.

#### Andrew Poulsom

##### MrExcel MVP
Try eg:

=SUMPRODUCT(1/COUNTIF(A1:A5,A1:A5))

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,164,382
Messages
5,836,931
Members
430,463
Latest member
mikmob

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