+ Reply to Thread
Results 1 to 5 of 5

Need help with ratelist for dhl in shipments

  1. #1
    Registered User
    Join Date
    02-08-2022
    Location
    sialkot
    MS-Off Ver
    Microsoft Office Professional Plus 2016 64BIT
    Posts
    60

    Need help with ratelist for dhl in shipments

    Dear All,

    kindly find the attachment and plz help me with a single line formula,
    in sheet SBD in Colum (S) i have weight and in Colum (AM) i have country name i need rates in Colum (CB)
    in sheet C in Colum (A) i have Zones and could (B) i have country names,
    in sheet DHL i have weight in Colum (A), ZONES from Colum (C) to (Z),
    but after 30 kg there are only per kg rate which have to multiply manually,
    i need a single line formula which calculates the exact rate for the shipment kindly help file attached for reference,

    waiting for your kind reply,
    please do not use VBA scrips please,
    this file is in .xlsb format, because original file contains more than 72000 entries,
    but this file have only needed entries only like 20 entries.
    Attached Files Attached Files
    Last edited by kisiji; 06-28-2022 at 02:01 PM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Need help with ratelist for dhl in shipments

    Hi. I am roaming on an expensive metered connection and WILL NOT download a massive file.. Read the yellow banner (top) about SAMPLE sheets and post a sample with 10-20 rows.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365 Version 2404
    Posts
    1,259

    Re: Need help with ratelist for dhl in shipments

    Please try in CB4 and drag down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Good luck!

  4. #4
    Registered User
    Join Date
    02-08-2022
    Location
    sialkot
    MS-Off Ver
    Microsoft Office Professional Plus 2016 64BIT
    Posts
    60

    Re: Need help with ratelist for dhl in shipments

    Dear Estevaoba,

    Thank you very much for your positive reply,
    it have solved my all problems,
    a bundle of thanks,

    GOD bless you.

  5. #5
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365 Version 2404
    Posts
    1,259

    Re: Need help with ratelist for dhl in shipments

    You're welcome. Glad to help.
    Thank you for the feedback and for the reputation added.
    Have a blessed day!

+ 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. [SOLVED] Tracking Detained Product Shipments and Values
    By kellyjo7 in forum Excel General
    Replies: 1
    Last Post: 04-19-2022, 03:23 AM
  2. [SOLVED] Trying to count number of Shipments that aren't shipped on same date
    By Chris McGlothen in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-09-2017, 10:33 AM
  3. Looking for Ideas; Matching Shipments with Receipts
    By SirMallek in forum Excel General
    Replies: 0
    Last Post: 03-05-2015, 07:11 PM
  4. Track Multiple Shipments With Multi Carriers
    By Fredbugatti in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-25-2014, 12:42 AM
  5. [SOLVED] Help with Formula to Classify Shipments based on differnt materials on an order
    By Pi* in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-06-2013, 09:59 AM
  6. Replies: 6
    Last Post: 02-20-2012, 06:07 PM
  7. how do i chart a 24 month moving average of sales shipments
    By lostinred in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-20-2005, 09:05 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