Forum Discussion
How to calculate distance between values
I have the following cells and I want to calculate the distance between 1 values. The database is big with over 100k values so I want to be able to either do it automatically or by dragging the formu...
Maybe with Power Query. In the attached file you can add data in the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh.
In the example cell A2 is cell number 1 and cell B2 is cell number 2 and so on.
