Count Repeat Clients Visits only

[Jman]

I need a formula or a macro, that counts the total of visits of clients that
have come in more than once. All one visit clients i want them ignored.

Ex in Column A "Client Names" i have a thousand names.

John Dow
John Dow
Brian McKarther
Julian Mazilu
Chris Smith
Chris Smith

The total of repeat clients visits should be ... 4 visits.
Since "john dow" came twice and "Chris Smith" came twice also = 4 . Brian
and Julian should not be counted.
How can i get a formula to count that for me.

 

[Max]

Try: =SUMPRODUCT(--(COUNTIF(A1:A6,A1:A6)>1))

 

[muddan madhu]

I think this will help u,

=SUM(IF(FREQUENCY(MATCH(A1:A6,A1:A6,0),MATCH(A1:A6,A1:A6,0))>1,1))

 

[Jman]

Try: =SUMPRODUCT(--(COUNTIF(A1:A6,A1:A6)>1))

 

[Jman]

I think this will help u,

=SUM(IF(FREQUENCY(MATCH(A1:A6,A1:A6,0),MATCH(A1:A6,A1:A6,0))>1,1))


Your formula is good, but it counts a repeat client as one instead of total amount the repeat shows up . .The obove formula by "Max" does the trick.

 

[Max]

Welcome. But could you take a moment to press the "Yes" button below from
where you're reading this? It'll ensure a longer shelf life to this thread
for the general benefit of other readers.