comparing rows of data in excel

[wdverner]

hi all,
i wish to carry out some detailed analysis of ROWS of data in excel.

Each row has 10 columns on data.
There are 5 rows.

What i want to do is compare row 1 with row 2 and count the number of differences between the 10 columns of numbers.

I will then count the differences between rows 1 to row 3 and so on....

How is this best achievable?

Many thanks

 

[sawedoff]

Put the following formula in a location that will not show or be in the way.

=if(A$1=A2,0,1)

Copy it down 5 cells and then copy all across until you have a 10 column block. Sum the 10 x 5 block.


Sawedoff