pulling distinct data to another sheet
I have a worksheet which I am working metrics on a separate worksheet. I have a list of courses on the main sheet and they can be duplicates. What I am trying to do is pulling those distinct courses onto another worksheet and I can use count how many times they are used for, but I need to pull that distinct courses from a worksheet -
So
Worksheet A
Course 1
Course 2
Course 1
Course 1
Course 2
Then i want to pull those courses onto another worksheet - but distinct -
Course 1
Course 2
How would I do that?
Best Answer
-
You would need a helper column on the metrics sheet (called "Number" in this example). You would manually enter the numbers 1 - whatever to cover the maximum number of possible unique classes. I also suggest a bit of a buffer just in case.
Then the formula to pull in the distinct list would be
=IFERROR(INDEX(DISTINCT({Course List}), Number@row), "")
Answers
-
You would need a helper column on the metrics sheet (called "Number" in this example). You would manually enter the numbers 1 - whatever to cover the maximum number of possible unique classes. I also suggest a bit of a buffer just in case.
Then the formula to pull in the distinct list would be
=IFERROR(INDEX(DISTINCT({Course List}), Number@row), "")
-
Thanks, it works. I just wished that there is a way for us to do that without the "helper" column, but I am able to get what I need with your suggestion.
Thank you!
-
Happy to help. 👍️
You can do it without the helper column, but then you would have to replace "Number@row" with a hardcoded number and change that on every row.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!