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
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
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
Related:
- How can find unique data
- Tmobile data check - Guide
- Gta 5 data download for pc - Download - Action and adventure
- Digital data transmission - Guide
- Data transmission cable - Guide
- Transfer data from one excel worksheet to another automatically - Guide
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
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