| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 14 Clients | Excel Discussion (Misc queries) | |||
| Can I merge data of 200 clients into an invoice template? | New Users to Excel | |||
| How do I create an investment portfolio for my clients? | Charts and Charting in Excel | |||
| How Do I organize sheets and clients by town? | Excel Worksheet Functions | |||
| Match a name to all clients? | Excel Worksheet Functions | |||
Hybrid Mode
