I am not sure this is even possible to do in excel but am hopeful for some suggestions. I have a spreadsheet of clients and the dates of service each client has received in the last 6 weeks. i am tasked with determining how many of the clients in the spreadsheet received at least 2 services a week. All service dates are in one column...which may pose a problem. Thanks for any insight anyone may have.
Vicki
Vicki