VBA Needed for all possible two-pair combination of cells

I have a large dataset that I need a macro/vba to compute a two-pair combination of all cells into an index in the form (a1-a2)/(a1+a2). I want to take cell a1 and apply the calculation to all cells i.e. a1....an, and then move to cell a2 and so on till all cells are covered.

I am attaching a sample of my dataset

Thank you in advance for your help

It's not clear, do you need also all values in other columns like (a1-b1)/(a1+b1)

Each column represent a different sample. I need to loop through one column at a time or I can repeat the process

That kind of sounds like homework. :P

Still, here is my suggestion. Try using a loop that goes through all the cells one by one. Put another loop into it, that goes through all the cells again. Something like this:

Please Login or Register  to view this content.

Sounds like that but it is not. I am doing some research and I'm thinking through the data to see what i can do with it.
Thank you. Will try it