Could you set up a pivot table and using the top left box, select
whether current period or not, and then put client code number as row
headers, and in the middle use sum of client code number.
I think this will tell you how many times each client has visited in
the current month.
--
robert111
------------------------------------------------------------------------
robert111's Profile:
http://www.excelforum.com/member.php...o&userid=31996
View this thread:
http://www.excelforum.com/showthread...hreadid=529174