proximity

  1. H

    Formula to show a date based on a proximity score

    Hi all. I have a document in which a score (1 to 5) is used to indicate a time period in which it is felt a risk would be likely to occur. Closer that risk is to actually happening, the higher the score. The scoring is as follows and is entered manually by the user: 5 is within a month, 4...
  2. M

    Proximity Using Multiple Lat and Long

    I have a huge spreadsheet of locations with lat and log. I need to calculate the distance between all locations from each other within a specific state, as well as finding the locations closest to each other. I have the basic formula for calculating distance between point A and point B. Is...
  3. M

    Solution to find the value two cells to right of a reference cell which can change

    Hi, Could someone help with an excel query? I want to find the most recent date for each person and then choose the value two cells over for each ID? The following does not work as the MAX() range includes a mixture of dates and values: =HLOOKUP(MAX(A1,E1,I1),A1:L1,2,0) The database is...
  4. A

    Expert level: Proximity matching for latitude/longitude

    Hi Excel Geniuses I've got a doozy of a question. I'm trying to take a center point (lat/long) and then use that value to reference a table to find the three closest matches by lat/long proximity. Here is a simplified example: The first spreadsheet has the centering location value and we...

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