Comparing 5 worksheets
 

Hi,
I am in a problem. I have 5 sheets of data. Each has about 100 columns
and 80 rows of data.
I need to compare these 5 sheets with each other. Basically what i am
looking for is that i would like to find out how one particular cell in
one sheet compares with the other 5. I need the mean of each cell on all
5 sheets and i need the differences. I am trying to calculate the
coefficient of repeatability. For that after calculating the mean i
need to subtract each cell from the mean of the 5.

Another issue is that the data is arranged in concentric circle form.
The centre point of the data is the value 0 in a cell. But this 0 does
not fall at the same place in all the cells. It can shift a cell or two
vertically or horizontally in the sheets. I would like to be able to
specifiy the 0 as the starting point for this data or somehow get it to
take the o as the starting point itself.

Could someone help me out with this please. I would really really
appreciate it.


Thanks




--
thewildleo
------------------------------------------------------------------------
thewildleo's Profile: http://www.excelforum.com/member.php...o&userid=36843
View this thread: http://www.excelforum.com/showthread...hreadid=565500