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