I'm working on a spreadsheet to track the clients seen in our facility. I have one in which every client will be entered, including recurring clients. This is a continuously used spreadsheet that will not have data deleted.
I want a second sheet that references the first, removes the duplicates, but enters the subsequent visit dates in order in each column.
So as you see, patient 533 above would only be entered once, but the visits would be entered across the row for each visit.
I'm sure this isn't as hard as I'm making it, but it's time to ask for help after fighting with
it for a few hours.
Any help is greatly appreciated.
I want a second sheet that references the first, removes the duplicates, but enters the subsequent visit dates in order in each column.
So as you see, patient 533 above would only be entered once, but the visits would be entered across the row for each visit.
I'm sure this isn't as hard as I'm making it, but it's time to ask for help after fighting with
it for a few hours.
Any help is greatly appreciated.