jeudi 20 octobre 2022

calculating the distance between cells in excel (randomize moving cells)

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.

Sample Table

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