How can find unique data

[Closed]
Report
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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