Hi Guys,

I am currently on a problem that I can't figure out how to do.
The situation is as follows:
I have one column of processes (alphanumeric codes), with a lot of duplicates.
Then there is a separate sheet with the what the processen contain in terms of Qualifications. The proces are listed in column A and the qualification in column B. If a process includes multiple qualifications the proces in listed again on the next row with the different qualification in column B.
What I need is a formula/action that can look up what qualifications are included per proces (including all duplicates processes) and add all the qualifications in a list, so they can be counted afterwards.
I tried the Index Match combination but that only includes the first qualification of the processes that have multiple qualifications.

Hope you guys have any idea how to tackle this?

Thanks!