Unique names from a list of names

Is there any formula in smart sheet which can show all the unique name from the column containing various names????

I have tried many formulas mentioned in various discussion in smart sheet community but none of them are working properly,

If possible, kindly share the link of discussion which can solve my problem or share the formula

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!