mercredi 5 août 2015

calculate difference between cells in an array [on hold]


I want to calculate the difference between every cell in one primary row to other rows and then sum the diff.

Primary row: - [11,19,59,69,9]

other row:   - [10,20,30,20,50]
diff         - [|11-10|,|19-20|,|59-30|,|69-20|,|9-50|] = [1,1,29,49,41] 
sum(diff)    = 1 + 1 + 29 + 49 + 41 = 121

How can i do it ?



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire