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
v-jiascu-msft - Hi Dale, I've added an example to the thread