Need to extract Non-duplicate values

Options

Hi, I'm in the need of extracting the Non-duplicate values in a range. I could able to achieve same in the excel (Formula =UNIQUE(A2:A16)). See the attached excel schreenshot. I knew Distinct function is a replacement of unique in smartsheet but it can be used within the other function and not working propery. Kindly suggest same to achieve in the smartsheet.


Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!