How can find unique data

Closed
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Mar 8, 2011 at 12:10 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 8, 2011 at 06:23 AM
Hello,

I have a data from April 2008 to Feb 2011 and i have to find no. of unique member visit every month. every member having a card no. and he/she may visit more than one in a month.

Can i find how many unique member visit month wise using pivot table. or there is any other criteria to find out same.

Thanks!
Rahul

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 8, 2011 at 06:23 AM
use advance filter to get all unique card number on a sheet. the u can use sumproduct or bunch of countif in sequence to get the count
0