Need to extract Non-duplicate values


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.


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!