Forum Discussion

saferguson's avatar
saferguson
Regular Visitor
8 years ago

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 ...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

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

  • saferguson's avatar
    saferguson
    Regular Visitor
    8 years ago
    StoreLatLongSize (sqm)Region
    A51.50735-0.12776100London
    B51.51178-0.12319200London
    C53.48076-2.24263300Manchester
    D53.40837-2.99157200Liverpool
    E36.31342-95.6216100Bath
    F52.40682-1.51969150

    Coventry

     

    Here's an example, there are a few more columns but these are all details not needed for the calculation

  • saferguson's avatar
    saferguson
    Regular Visitor
    8 years ago

    v-jiascu-msft - Hi Dale, I've added an example to the thread