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
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 443 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!