+ Reply to Thread
Results 1 to 4 of 4

Country Codes rate comparison from different vendor

  1. #1
    Registered User
    Join Date
    12-16-2013
    Location
    Miami, FL
    MS-Off Ver
    Excel 2003
    Posts
    2

    Country Codes rate comparison from different vendor

    Hi Everyone,

    New to the Forum seeking assistance from you regarding the following:


    A Customer sent a list of Country Codes from A - Z destinations with Target rates.
    A Vendor sent a list of Country Codes from A - Z destinations with Selling rates.

    Task 1
    Need to create an excel formula that will allow to compare the customer's country name, Customer's country codes and identify if the vendor's rate is lower than the customer's Target Rates. if the vendor's rate is lower, then it must be display and match the country code..

    Attached find the is an example of the codes

    Attachment 284508

    Would really appreciate for your assistance in putting together this formula.

    Thanks in advance!

    Regards,

    Maagjoel

    
    Attached Files Attached Files
    Last edited by maagjoel; 12-17-2013 at 09:29 AM.

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Country Codes rate comparison from different vendor

    pl attach file in excel format.

  3. #3
    Forum Contributor geliedee's Avatar
    Join Date
    10-14-2013
    Location
    Manila, philippines
    MS-Off Ver
    Excel 2007
    Posts
    399

    Re: Country Codes rate comparison from different vendor

    maagjoel,

    Please attach an excel workbook so all of us can work on it.
    Last edited by geliedee; 12-17-2013 at 03:24 AM.

  4. #4
    Registered User
    Join Date
    12-16-2013
    Location
    Miami, FL
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Country Codes rate comparison from different vendor

    My apologies!
    Please check now the limited version of the A thru z country code list.

+ 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. I need Macro(VBA code) to Highlight Invalid Country Codes in a column
    By narendrabr in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-27-2012, 12:16 PM
  2. [SOLVED] Adding country codes to a phone number... Please help
    By percyth1 in forum Excel General
    Replies: 1
    Last Post: 03-08-2012, 10:38 PM
  3. Lookup rate based on vendor and date range
    By June12 in forum Excel General
    Replies: 3
    Last Post: 06-30-2011, 09:21 PM
  4. Replies: 3
    Last Post: 03-20-2010, 11:17 AM
  5. Add ‘country name’ column to worksheet from a list of country codes.
    By Ben Morton in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-02-2009, 09:24 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