# Count, without repeating...

#### evilacha

##### New Member
HI guys, I'm getting addicted to this board, its very usefull. What i have its a sheet that has a column with clients and other column thats like a conditional, i want to count all the clients that have that conditional without counting a client twice... because the client list have clients that apper more than once...

Thanks for all your help guys.

### Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
=IF(COUNTIF(\$A\$1:A1,A1)=1,1,0)

where column A has the client. So wherever the answer shows 1 is a unique count of that client.

I tried that, but aint working... let me show you a small example:

[ B ][ L ]
[ IND ] [ ]
[ IND ] [ ]

So what i want to do its to count how many clients, meet the "Aladi" Requirement... in this example it would be 2: Acme and LASYS, because IND doesnt meet the requirement and it must count each client just once.

tHX man i made a way through your formula, I starded with a filter, to show the Aladi clients, after that I applied your formula and made a sum of all the " 1 " and it worked.

or try this

I tried that, but aint working... let me show you a small example:

[ B ][ L ]
[ IND ] [ ]
[ IND ] [ ]

So what i want to do its to count how many clients, meet the "Aladi" Requirement... in this example it would be 2: Acme and LASYS, because IND doesnt meet the requirement and it must count each client just once.
Book4
BCDEFGHIJKL
2
4IND
8IND
9
10
11
12
13
14
152
162
17
Sheet1

B15:

which needs to be confirmed with control+shift+enter, not just with enter.

Or, alternatively, if you have installed the morefunc.xll add-in:

B16:

which also needs to be confirmed with control+shift+enter, not just with enter.

Replies
0
Views
192
Replies
3
Views
178
Replies
4
Views
140
Replies
3
Views
158
Replies
21
Views
569

1,202,977
Messages
6,052,888
Members
444,608
Latest member
Krunal_Shah

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