Hi, I have been assigned the task of fixing the duplicate Unique Reg. Numbers for a very large hospital.
I have a template set up and was hoping there is some way I could only show the rooms that have two or more of the same UR numbers. Meaning if the UR number shows up more than once in the project, I want to see it. And if it only shows once, I do not want it in the schedule.
This would really cut down on the amount of time I am spending looking through every single room for duplicates.
Thanks for any help you guys can give me on this. Very new to formulas, so if that is how to go about this be very gentle in your explanation