Suppose I want to compute the distance between a 3by4 cells in a square grid in excel. The distance between two cells is 1m.
Each grid cell is a number between 1 and 12 but randomized so every number can be anywhere.
For instance: (example in the bottom-left side of the grid):
1___2___3___4
5___6___7___8
9__10__11__12
distance between cells 1 and 5 is 1
distance between cells 1 and 6 is 2
distance between cells 1 and 12 is 5
Is it possible to have the formula to be able to calculate all of the distance between 2 cells????
Thanks for any help in advance! :)
Aucun commentaire:
Enregistrer un commentaire