I think this is practically impossible.

"I have set of 2 data in column A and B which give a result in Column C"

Can you be sure without any doubt that C is the result of some formula PURELY between A and B or could there be other values involved?

If there may be other values AT ALL then I'd say this is impossible without knowing those values.

Can you not go back to the data source and request how the results are obtained?

Yes it is a formula, and both values in A and B are involved as changing a value in A and B will change the result, Point is to find the Factor ,

if I knew that factor I wont be asking here. I want to setup a loop script that will test that X and Y factor and try to find same factors that applies to all. What I am sure is that Factor must be same (or maybe obtain by doing some math between A and B).

Hypothetically lets imagine that there are 2 Factors X= 2 Y=3

=(A9*E8)+(B9*G8)

2 4 16

5 7 31

9 12 54

But If X and Y are unknown and Formula of C is unknown too, how will you go find them ? Isn't there anyway to loop through VBA to find out something common ??

I know it seem a little hard, but I saw there are some script that let you reverse the value to find formulas, but I cant find anything that match my request. I hope someone lese have a better idea ho to do so.

Thanks