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@gmail.com