Can January (Col B) have one name more than once? yes
Can Names (Col A) have one name more than once? yes


When i enter the =(ISNA(VLOOKUP(B1,A:A,1,False),"",1))

formula it says i've entered too many arguments.

"Sheeloo" wrote:

Do you want to count the names in January which are also there in names column?
Can January (Col B) have one name more than once?
Can Names (Col A) have one name more than once?

One way...
You can enter this next to January column (in C1)
=(ISNA(VLOOKUP(B1,A:A,1,False),"",1)) and copy down
Sum of column C will give you the count of names in January which are also
there in Names...

If names can be repeated in Col B then use
=SUMIF(B1:B100,B1,C:C) and then sum only cells with 1 ...
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"Jman" wrote:

I clarified it a bit more..



Ok, i have this formula that works for me counting only the Clients in
column A$A, but i want do add another column to it. And for some reason it
does not work, the "january" column.

=SUMPRODUCT(--(COUNTIFA1:A65530,A1:A65530)=1))

I want the formula to look in "january" column and based on Column "client
name" to tell me which client in Janary is typed in only once. in bottom
example woul be Mike and Laura to be correct, ( and add them as 2 clients) id
dont need their names. So it should be total of 2 clients have come in Janary
based on all the clients in A$A column


"CLIENT NAMES" "January"
A1: A65530........................................B1:B 200

John Doe ............................................Mike Mcarthur
Chris Jones .........................................Laura Williams
Joh Doe ..............................................John Doe
Chris Jones
Dana Berindei