Alerts on duplicate values
We are assigning a unique identifier across 3 separate sheets. The unique identifier creation is a manual process at this stage as this is a short term problem we are solving for. Is there an automation that we can use to notify if there are two of the same values for different lines? We have a report pulling in the data to one place but wasn't sure how to run an automation across multiple sheets.