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
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!