"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