distance

  1. C

    Distance & Time Calculator (Chandoo)

    Hi All, Hoping to get some help, I'm using the distance and time calculator, that is supplied on the chandoo website, I have my API for bing and everything is working 100% when I save things locally, I have it integrated into a excel project calculator for projects. Which basically calculates...
  2. V

    Sumproduct Multiple criteria same column

    Pls help I want to find the Weighted average of the following data in a single column : I have tried Sumproduct(--(Heads="Freight")*(Value),(Heads="Sale")*(Value))/Sum(Sale) COUNTY Heads Value A Sale 200 A Freight 35 A Distance 50 B...
  3. D

    Complex Distance Formula

    Hi, I am trying to find the nearest distance between many points. I have a set of about 300 coordinates that I am comparing to a list of about 4k coordinates. I am using the formula...
  4. E

    Longitude Latitude Question

    Hi, I am trying to find a formula that would determine the distance (in feet) that these two coordinates varied from. In this case, to be expressed as "X" (amount of feet south) and "X" (amount of feet west) or original point. Then total distance as the crow flies. <tbody>...
  5. R

    Calculating Average Speed from hh:mm:ss and known distance

    Afternoon, Hope someone can decipher this code because I've looked and looked at it and it is WAY beyond my capabilities. I was kindly given the spreadsheet by another organiser but would like to refine it slightly. It's for a time trial. Basically, the event distance is entered at the top...
  6. D

    Distance between points - matrix

    Hey, i'm trying to make a table that looks like this: <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>#DAE7F5[/URL] "] B C D E F G </thead><tbody> 17 #FFFF00[/URL] , align: right"] #FFFF00[/URL] "]0 #FFFF00[/URL] "]5 #FFFF00[/URL] "]10 #FFFF00[/URL] "]15...
  7. M

    Extract informations if distance (lat,long) between two lists of places is lower than 50km

    Hello, I have two lists of places (in two Excel sheets) : cities and swimming pools. I have the lat and long of all the places (for the cities it's the center). I want to extract a list of all the pools nearby every cities. So I would have a final list like this : - Name of the city / CityLat...
  8. G

    Count function help - determining "drive time" distance

    Hello, Is the below example possible? I've been able to determine how many people live within a certain distance (in miles), thanks to this board (thank you!), but now I'm looking to determine how many people live "within a 30 minute drive", using lat. long. coordinates as the reference points...
  9. B

    Driving distance calculator

    Given that I have the mileage between motorway services, I want to be able to enter the names of any two of the services to calculate the distance between them. It must be simple but it's got me baffled.
  10. D

    Calculate new coordinate with distance

    In my mind this is simple - it is probably an excel nightmare: My company has a geographical map that needs thousands of coordinates pinned so it can be accessed through a map app. The coordinates are close - so I want to pin one coordinate and calculate the next by adding a few feet in...
  11. L

    Excel Formula or Macros - Distance Between Two Postal Codes

    Hi, I'm from Canada & I'm trying to see if there is a formula or macros I can use to calculate the distance between two postal codes for Excel 2007. A1 - Postal Code 1 B1 - Postal Code 2 C1 - Distance Any help would be greatly appreciated. Thanks, Laurinda
  12. L

    Excel Formula or Macros - Distance Between Two Postal Codes

    Hi, I'm from Canada & I'm trying to see if there is a formula or macros I can use to calculate the distance (KM) between two postal codes. A1 - Postal Code 1 B1 - Postal Code 1 C1 - Distance (KM) Any help would be greatly appreciated. Thanks, Laurinda
  13. D

    Debug help

    Hi all, i cannot debug this code, i suspect it's not pushing the postcodes into the website but it's giving me precious little feedback as to whats wrong - any ideas? Sub Postcode_Distances() Dim URL As String Dim count As Integer Dim waitCounter As Integer Dim fromCheck As String Dim toCheck...
  14. T

    VBA Help: Using *Insert Row* to adjust distance between random distance of Row A to cell containing "ID #"

    I'm a bit new to VBA. But, I've gotten pretty far into this project at work. However, I've come across a logic problem that I don't have a knowledge base wide enough to complete: The problem goes like this: I have many Work books that I need to export to a master WB one at a time (this wb then...
  15. R

    Multiple IF statement for radius mile

    Hello I have distance in my data that I would like to categorise into radial areas (The cell containing the distance is AN2). For example 10 and under is Area 1, 10.1 to 15 is Area 2, 15.1 to 20 is Area 3, 20.1 to 25 is Area 4 and anything greater than 25 is Area 5. Any help would be greatly...
  16. N

    Weighted Average with Two Weighting Criteria

    Thanks for your help in advance... I have to figure out pricing, using a weighted average. But I have two Weighting Criteria. Dates & Distance (Fractions of a Mile). <colgroup><col><col><col></colgroup><tbody> Date of Sale Distance Pricing 11/6/2017 0.12 654.36 7/11/2018 0.21 765.31...
  17. T

    Distance Calculator for excel between two citys with kilometer result

    Hello kings of the formula i want to Distance Calculator for excel between two citys like this one
  18. E

    Calculate Minimum Distance Between Lat Long

    Hello Every one , First Thanks in advance if you solve my query . I am having a data base of 100+ lat long(Main data) , Now I am having other database which contain 20,000 + Lat Long(reference database) . I want to calculate one of each lat long of my Main data with each and every lat long of...
  19. JenniferMurphy

    Is there a simple way to record optional subtotals?

    I am trying to get in better shape. One part of my regimen is running (jogging). I usually just go out and run one of several routes in our neighborhood that I have mapped out with Google Maps so I know the distance. I take a stopwatch and time the run. When I get back, I log the date, distance...
  20. K

    Count the distance Between 1 and 2

    Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> I want to count the distance between the character "1" and "2", count start should be with "1" and to last "2" </SPAN></SPAN> Data are in columns C:P, and the count results are shown in the columns S:AF</SPAN></SPAN> Note optional request: if...

Some videos you may like

This Week's Hot Topics

  • SUMPRODUCT active link formula
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
  • IF FUNCTION FIRST, THEN WITH INDEX AND MATCH
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

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
Top