+ Reply to Thread
Results 1 to 3 of 3

multi IF THEN with text AND distance between 2 addresses

  1. #1
    Registered User
    Join Date
    12-20-2014
    Location
    chicago
    MS-Off Ver
    Office 2013
    Posts
    10

    Post multi IF THEN with text AND distance between 2 addresses

    I have a zillion rows
    I'm trying to put in the address for several locations without having to retype each one out

    in the spreadsheet each ID will have an address that will repeat.

    if there's an ideal way to type in addresses let me know!

    ALSO

    is there a way to copy/paste certain entire rows into a new sheet based on a column? ex if column a=0 copy that row if a=1 don't copy entire row

    THEN

    if anybody knows how best to find distance between two addresses (for a zillion columns) without individually looking it up... PLEASE LET ME KNOW!

    good luck
    Attached Files Attached Files
    Last edited by kaczynski; 06-26-2015 at 03:02 AM.

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    2,265

    Re: multi IF THEN with text AND distance between 2 addresses

    Not sure what you after when I look there is nothing example of the expected results, needs more clarify


    thanks

  3. #3
    Registered User
    Join Date
    12-20-2014
    Location
    chicago
    MS-Off Ver
    Office 2013
    Posts
    10

    Re: multi IF THEN with text AND distance between 2 addresses

    Sample added
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculating distance between addresses
    By funkmeister79 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-03-2015, 01:06 PM
  2. Distance between 2 addresses
    By kaczynski in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-14-2015, 05:51 AM
  3. [SOLVED] Google Distance Matrix API - Distance and Time
    By rtcwlomax in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-18-2014, 08:42 PM
  4. [SOLVED] Edit distance (Levenshtein Distance) using Excel
    By cool_anu4u in forum Excel General
    Replies: 4
    Last Post: 10-09-2013, 08:46 AM
  5. VB code to "Send To" Multi addresses
    By muzzas news in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1