Skip to main content

Hi all, I have a map showing locations of customers linked to store locations. I have calculated the nearest store to each customer and can show the customer locations on the map but am unable to show the nearest store locations on the same map/

 

What I would like is to show both on the same map. The customers in 1 colour/symbol, and the nearest stores in another colour.

 

Is this possible?

 

I would then use a filter to select each customer to show their nearest store, or do this geographically by region etc.

 

I have attached the workbook as it is so far.

 

Thanks in advance.

6 answers
0/9000