calculate multiple percent differences

**Moriarty4** · 01-27-2011, 03:04 AM

Hi there

I got a problem:

I got multiple measurements which I want compare. So I want to calculate the percent differences. So far no problem, but I got so many values, that I cant to it by hand. To make it more clear, in principal I got two coloums with a different number of values in both coloums. I want now to compute the percent differences of ALL combinations between the values of both coloums.

Do you know any formula or macro which I can use for this problem?

I am not a VBA programmer, so a ready to use macro would be perfect.

Thanks a lot in advance!!!

Cheers

Florian

**johnjohns** · 01-27-2011, 04:25 AM

Please provide a sample workbook and we understand your issue better.

**Moriarty4** · 01-27-2011, 04:51 AM

okay, here is a very simple example:

in A and B are the values. In C are the calculations, for this example six, but as I said, the number of values differ and is in reality a lot more than this...

Hope this helps...

Cheers Florian