Looking for 1.00 difference in 2 columns

[panyagak]

Hi.

Let me be brief:
I have values in 2 columns B & C.
Column A has 1,2,3,4,5,6,7,8.....to any number.

I need a code to multiply column A values with column B & C values separately with both resultant values substracting from each other until a 1.00 difference is detected.

Example (a): 0.74 and 1.56
14*0.74=10.36
6*1.56=9.36
Difference=1.00

Example (b): 0.47 and 1.28
36*0.47=16.92
14*1.28=17.92
Diff=1.00.

I did these 2 manually. Suppose I have over 1,000 of these?

Please HELP - my shoulders are aching.

Patrick

 

[panyagak]

Uh!!

Thats the most frequently used formula in my data analysis & didnt see it !!!

Its my obsession with vba codes anyway, thanks Eric W.

Regards
Patrick

 

[Eric W]

Sometimes it just takes another set of eyes. Glad you got it sorted.