Count Repeat Clients Visits only

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jman - 27 Mar 2008 10:52 GMT

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.

Reply to this Message

Max - 27 Mar 2008 13:50 GMT

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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.
[quoted text clipped - 12 lines]
> and Julian should not be counted.
> How can i get a formula to count that for me.

Reply to this Message

Jman - 27 Mar 2008 20:56 GMT

> Try: =SUMPRODUCT(--(COUNTIF(A1:A6,A1:A6)>1))
> > I need a formula or a macro, that counts the total of visits of clients that
[quoted text clipped - 15 lines]
> >
> > Thanks your formula did the trick.

Reply to this Message

Max - 27 Mar 2008 23:53 GMT

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.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Thanks your formula did the trick.

Reply to this Message

muddan madhu - 27 Mar 2008 14:55 GMT

I think this will help u,

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

> 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.
>
[quoted text clipped - 9 lines]
> and Julian should not be counted.
> How can i get a formula to count that for me.

Reply to this Message

Jman - 27 Mar 2008 20:58 GMT

> I think this will help u,
>
[quoted text clipped - 17 lines]
> > and Julian should not be counted.
> > How can i get a formula to count that for me.

Reply to this Message