Compare Columns

[df]

Hello,

my data looks like this:

	spend1	spend2	spend3	spend4	...
row1	10	10	12	12	...
...	...	...	...	...	...

Now i want to compare evey column (like spend2 / row1) with the entry at the beginning. For example compare "spend2 /row1" with "spend1 /row1" - then "spend3/row1" with "spend1/row1".

The result sould get an entry in a new column in same row or in a new row.

The output should look like this:

	spend1	spend2	spend3	spend4	spend2/spend1	spend3/spend1	spend4/spend1
row1	10	10	12	15	100%	120%	150%

or like this:

	spend1	spend2	spend3	spend4
row1	10	10	12	15
output	-	100%	120%	150%

may someone can help

[Claje]

Hi,

You should be able to do this with a series of formulas.

Do you have a variable number of Spend fields?

[danrh · Accepted solution]

Try the attached.  This should scale to however many rows/columns you're dealing with:

Hope it helps!

[df]

Thank you very much :)
thats what i wanted.