Path: csiph.com!xmission!news.glorb.com!Xl.tags.giganews.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!local2.nntp.dca.giganews.com!nntp.newsgroupbanter.com!news.newsgroupbanter.com.POSTED!not-for-mail NNTP-Posting-Date: Mon, 12 Oct 2015 18:49:03 -0500 From: rtour957 Newsgroups: microsoft.public.excel.programming Subject: Tracking unduplicated clients Date: Tue, 13 Oct 2015 00:41:10 +0100 Message-ID: Organization: ExcelBanter.com User-Agent: X-Newsreader: X-Originating-IP: Lines: 14 X-Usenet-Provider: http://www.giganews.com X-Trace: sv3-YyCVHjdlJdFJtRcdaCusXGpJDr0xU/SoyPhLtJL+FG0Pdf3hk9d63Jb4JRxJ93aaYUjGBDxM/xHMlFN!MY5s38TlNi1uY0AJsUNGkhdNDeO8zHGYxevtLS5t/k2JiCRi8GQx7LmCMIFFkmkrWWAvKGRHhSiF!ci74VoBkRw== X-Complaints-To: abuse@newsgroupbanter.com X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.3.40 X-Original-Lines: 5 X-Original-Bytes: 1342 Xref: csiph.com microsoft.public.excel.programming:108096 Each clients has a unique number. Throughout a year they participate in different activities coded e.g. IS, CM, SW. They may participate in only one or all three of the activities. I need to come up with the annual report that would track unduplicated number of clients served in each of these activities. Any suggestions on how to do this would be highly appreciated. Thank you, Artur -- rtour957