Hello,

Normally, when I want to compare the difference as a percentage between 2 columns, A (old price) and B (new price), I use a simple formula B/A-1. This gives me the price increase as a percentage between B and A.

My problem is that I have 4 columns (with new prices) and 10 columns (with old prices) and I would like to compare any 1 of the 4 columns compared to any 1 of the 10 columns.

Is there a formula, where I can enter the letter or number of the columns into 2 different cells, it can calculate the difference as a percentage?

The heat is melting my brain and I cannot work it out.

I was thinking something like this, if in cell A1 I enter 4 and in cell B2 I enter 10, the formula calculates column4/column10-1.

Any help very much welcomed.

Thank you!