how to find out how many clients had 2 or more visits.
 

How can i find out how many clients had more than 1 visit..

I want to creat a formula that counts for me "how many clients have 2 or
more visits.. If possible with the pivot table..

how to find out how many clients had 2 or more visits.
 

"Jman" wrote:

How can i find out how many clients had more than 1 visit..

I want to creat a formula that counts for me "how many clients have 1 or
more visits..


for example

in columnt

A1 B1

John Mcarther Count as 1
John Mcarther
John Mcarther


Julian Boss Count as 0 (since it has no duplicate)


Chris Mccc Count as 1
Chris Mccc
Chris Mccc
Chris Mccc

B19 EQUALS TOTAL OF 2 DUPLICATES

how to find out how many clients had 2 or more visits.
 

Assuming your data in A1:A10 with a header in row 1
Select A1:A10 Data Filter Advanced Filter select Copy to another
location List range: $A$1:$A$10 Copy to: select $B$1 select Unique
records only OK

In C2: =(COUNTIF($A$2:$A$10,B2)1)+0
Copy down as far as you want



"Jman" wrote:



"Jman" wrote:

How can i find out how many clients had more than 1 visit..

I want to creat a formula that counts for me "how many clients have 1 or
more visits..


for example

in columnt

A1 B1

John Mcarther Count as 1
John Mcarther
John Mcarther


Julian Boss Count as 0 (since it has no duplicate)


Chris Mccc Count as 1
Chris Mccc
Chris Mccc
Chris Mccc

B19 EQUALS TOTAL OF 2 DUPLICATES

how to find out how many clients had 2 or more visits.
 

Try this:

=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))-SUMPRODUCT(--(COUNTIF(A1:A10,A1:A10)=1))

Biff

"Jman" wrote in message
...


"Jman" wrote:

How can i find out how many clients had more than 1 visit..

I want to creat a formula that counts for me "how many clients have 1 or
more visits..


for example

in columnt

A1 B1

John Mcarther Count as 1
John Mcarther
John Mcarther


Julian Boss Count as 0 (since it has no duplicate)


Chris Mccc Count as 1
Chris Mccc
Chris Mccc
Chris Mccc

B19 EQUALS TOTAL OF 2 DUPLICATES

how to find out how many clients had 2 or more visits.
 

"T. Valko" wrote:

Try this:

=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))-SUMPRODUCT(--(COUNTIF(A1:A10,A1:A10)=1))

Biff


Thanks Much!!! this formula worked like a charm..
Julian

"Jman" wrote in message
...


"Jman" wrote:

How can i find out how many clients had more than 1 visit..

I want to creat a formula that counts for me "how many clients have 1 or
more visits..


for example

in columnt

A1 B1

John Mcarther Count as 1
John Mcarther
John Mcarther


Julian Boss Count as 0 (since it has no duplicate)


Chris Mccc Count as 1
Chris Mccc
Chris Mccc
Chris Mccc

B19 EQUALS TOTAL OF 2 DUPLICATES

how to find out how many clients had 2 or more visits.
 

You're welcome. Thanks for the feedback!

Biff

"Jman" wrote in message
...


"T. Valko" wrote:

Try this:

=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))-SUMPRODUCT(--(COUNTIF(A1:A10,A1:A10)=1))

Biff


Thanks Much!!! this formula worked like a charm..
Julian

"Jman" wrote in message
...


"Jman" wrote:

How can i find out how many clients had more than 1 visit..

I want to creat a formula that counts for me "how many clients have 1
or
more visits..


for example

in columnt

A1 B1

John Mcarther Count as 1
John Mcarther
John Mcarther


Julian Boss Count as 0 (since it has no duplicate)


Chris Mccc Count as 1
Chris Mccc
Chris Mccc
Chris Mccc

B19 EQUALS TOTAL OF 2 DUPLICATES