Getting a unique values from other sheet

Gowtham

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)

Mark.poole

There is a solution In this discussion.

https://community.smartsheet.com/discussion/52886/get-a-list-of-distinct-unique-values

Mark.poole

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!!!"