pulling distinct data to another sheet

I have a worksheet which I am working metrics on a separate worksheet. I have a list of courses on the main sheet and they can be duplicates. What I am trying to do is pulling those distinct courses onto another worksheet and I can use count how many times they are used for, but I need to pull that distinct courses from a worksheet -

So

Worksheet A

Course 1

Course 2

Course 1

Course 1

Course 2


Then i want to pull those courses onto another worksheet - but distinct -

Course 1

Course 2

How would I do that?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!