cartesian

  1. H

    Help on avoiding dupplicates (need distinct ID fields)

    Hi all, Due to a corrupt worker_ID table which I don't have write rights to, I get cartesian product on my query table below: workhours_id Date Amount worker_ID Productive 27567 05.07.2014 8,78 sein01 TRUE 27567 05.07.2014 8,78 sein01 FALSE 27568 05.07.2014...
  2. G

    Finding distance between multiple coordinates relative to a single coordinate

    So I have over 100 points that I need to find the distance to from a single Cartesian point. I was hoping someone out there could help me find a way to only have to put the coordinates in and have Excel work out the answers. I have done a little bit of work with Excel but am totally lost here...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top