Getting a unique values from other sheet

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
-
There is a solution In this discussion.
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.
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!