Make all id's related to each other using function.

Hi everyone,

I have the attached file which I need to make a relationship between all IDs with each other that are related to the same STOCK CODE

The demo file has a SOURCE and an OUTPUT sheet which have the requested OUTPUT.

I tried to have the same result by using the following function:

Formula:

Please Login or Register  to view this content.

But I couldn't remove the ID which I'm using as criteria

Would you please kindly help me to get all the data in the SOURCE sheet sorted as in the OUTPUT sheet?

thanks in advance.

Hello Glenn,

Thank you very much for your kind help. I still don't know where to use the function of giving the card IDs. but your demo worked.

Thanks again, dear.

Thank you very much.