Getting a unique values from other sheet

Options
Gowtham
Gowtham
edited 05/08/24 in Formulas and Functions

Hi,

Could someone help with formula for extracting the unique values of a column which is in master sheet to calculation sheet(basically from one sheet to another)

Answers

  • Mark.poole
    Mark.poole ✭✭✭✭✭
    Options

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

  • Mark.poole
    Mark.poole ✭✭✭✭✭
    Options

    Quoting @Michael Parker

    "Nice to see the different options.

    If your sheet has a unique Row Number column, you can solve this problem in one line of code:

    =IFERROR(INDEX(DISTINCT([Primary Column]:[Primary Column]), [Row ID]@row, 1), "")

    Distinct(Column: Column) returns the range of distinct values, but must be used with another function.

    Index( gets the distinct range, selects the row using our Row Number Column, and selects column 1).

    The IFERROR() function allows us to clear the cells that do not have a valid value.

    Hope this helps!!!"

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!