Generate every iteration of possible quotients for each row variable

Hello,

I'm not sure if this is best done with a formula or in VBA, but I'm trying to create every possible combination of ratios for a series of data. The ratio would be comparing each individual row to one another and restricted to the column. I may not be explaining this the best, so I've attached an excel file that has a representation of what current data would look like, and the target result. It seems I just need some sort of looping variable in there, but I have no experience with this. Thank you so much for any and all help!

Ryan

For the data layouts you provided.

Please Login or Register  to view this content.

Thank you everyone. Jindon, that worked perfectly. Thanks again for the help. I gave you all Rep.

Best,

Ryan

You are welcome and thanks for the rep.

Is there a way to tell it to skip blank cells so it doesn't crash when dividing by zero? Thank you again!

Try change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

You are a gentleman and a scholar good sir! Thank you for the help, your suggestions have worked flawlessly.

You are welcome.