Forum Discussion
Calculation across multiple rows
I have a data set of store locations (100+ rows) and want to work out for each row what it's next nearest store is, from the same list. To do this in excel I would use an array function work out the ...
Hi saferguson,
Please share a sample data. A formula is needed. But we can't create a formula without data and its structure.
Best Regards,
Dale
| Store | Lat | Long | Size (sqm) | Region |
| A | 51.50735 | -0.12776 | 100 | London |
| B | 51.51178 | -0.12319 | 200 | London |
| C | 53.48076 | -2.24263 | 300 | Manchester |
| D | 53.40837 | -2.99157 | 200 | Liverpool |
| E | 36.31342 | -95.6216 | 100 | Bath |
| F | 52.40682 | -1.51969 | 150 | Coventry |
Here's an example, there are a few more columns but these are all details not needed for the calculation