Count Repeat Clients Visits only
 

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.

Count Repeat Clients Visits only
 

Try: =SUMPRODUCT(--(COUNTIF(A1:A6,A1:A6)1))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jman" wrote:
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.

Count Repeat Clients Visits only
 

I think this will help u,

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



On Mar 27, 2:52*pm, Jman wrote:
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.

Count Repeat Clients Visits only
 

"Max" wrote:

Try: =SUMPRODUCT(--(COUNTIF(A1:A6,A1:A6)1))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jman" wrote:
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.

Thanks your formula did the trick.

Count Repeat Clients Visits only
 

"muddan madhu" wrote:

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.
On Mar 27, 2:52 pm, Jman wrote:
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.

Count Repeat Clients Visits only
 

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jman" wrote:
Thanks your formula did the trick.