|
fastelectron
India
5 Posts |
 Posted - 07/26/2013 : 08:03:28 AM
|
Origin Ver. : 8.5
Service Release : SR1
Operating System: Windows 7
Hi ,
I am facing a tedious task in some calculation.
I have 2 worksheets, say A and B.
A has 2 cols and n rows.
B has n+1 cols and ~150 rows. (1st col X and the rest all Y)
Now I need to divide the first col and each subsequent col of B
with each row values of A.
ie,
xn = B(1st col) / A(n row,1 col)
and
yn = B(nth col) / A(n row,2 col)
for all values of n.
I am having 8 such (A,B) pairs of worksheets, and I am already
crossing all the limits of sanity.
somebody plz save me.
thanks alot
-S.
---
|
|
calculation across 2 worksheets
