Dynamic "UNIQUE" Function
Is there any type of function similar to the UNIQUE function in Excel that I can use? I have a Master List on one Sheet (called "QMS Transformations Common List") and I want to use links for the first column on another sheet ("named "QMS Metrics Calculation - Workstreams"). In excel I could use the UNIQUE function, and it would also make sure there are no duplicates. But mainly it would allow me to use a link, which means I only need to update the data in one location.
Project Analyst | Core Quality Services (QMS Transformation)
Help Article Resources
Check out the Formula Handbook template!