pulling distinct data to another sheet

topazfae

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?

Paul Newcome

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), "")

Paul Newcome

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), "")

topazfae

@Paul Newcome

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!

Paul Newcome

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.