If att all possible in excel - find all linked cells in a matrix and produce a list

Hi guys,
Here is an interesting one, i am trying to unravell a matrix of hosts(H1 etc) and ports(F1 etc) where the relationship is many-to-many(one host can be connected to multiple ports and one port to multiple hosts). I can create a matrix listing all ports hoprizontaly, all hosts vertically and have a Y in the cell when there is a link. What I am trying to do is start from one cell and list all linked hosts and ports , sort of separate them in a cluster. Therfore it needs to be some form of recursive (i think it was called) algorithm to drill through the matrix and vertically and record all marked with Y hosts(H1..etc) and then for each host horizontally and record all linked with Y ports, while checking that there are no duplications.So for the below matrix(see the attachment - screen shot) when starting at cell H1/F1 the algorithm should return the following list - F1,F3,F5,H5,H8,H10,H13 as they are all linked, another run of the algorithm starting at cell H1/F2 should only return H2, F12 result, hope this make any sense at all and any help will be deeply apperciated!
Matrix.PNGAttachment 379983

Hello megarys,

Welcome to the Forum!

You should explain what you mean by "linked cells". The most common meaning of this in Excel refers to cells that depend on formulas for their results. I suspect this not case here.

Clearing up any confusion will help you get an answer more quickly. Whenever possible, you should post a copy of your workbook. This helps ensure that a solution can be tested on your data for accuracy and correctness.