Forum Discussion
Help Creating a way to track supervision visits
Its been too long since my statistics and microsoft office course in college! I need help creating a way to track supervision visits in Excel. As a supervisor, I have to see the client every 5th visi...
mathetes
Yes I think this will work, but on the second sheet, why is it giving the #NAME? error? How do I fix that?
Yes I think this will work, but on the second sheet, why is it giving the #NAME? error? How do I fix that?
Could you tell me where (which cell(s)) are giving that error?
Do you have the most recent version of Excel? There are some functions in this solution (UNIQUE and FILTER) that require the most recent version.
In the meantime, here's a slightly revised version which, if it's working on your system as it is on mine, uses conditional formatting to highlight the clients where your visit is most important.