carrier

I am wanting to have a outlook email address to be set based on the value of Combobox2. What i have doesn't seem to function, and i am sure it is simple but i am a little stuck. any suggestions would be great. What i have so far is: Dim name As String If ComboBox2.Value = "Bill" Then Set...

Thank you for any assistance you can give, I am trying to sum the revenue for each carrier based on the date and get the average for each carrier per month. I have the following formula which nets me the average per month based on all carriers, but I can't figure out how to obtain the results...

Hello, I'd like assistance with figuring out how to determine the name of a carrier based on how the first few characters of a tracking ID begin with. The problem is some characters can instantly identify a carrier by the first character and other can be identified by 2 or 3 characters...

Hi, I have a list of postcodes in column A, carriers in column B, and their rates in column C as below. I'm looking for a for a formula to replace "XXX" under the lowest cost section to look up the postcode in the list in column A and return the applicable carrier from column B based on which...

Hello, Looking for a way to automatically perform the following steps. I've tried Mail merge and VBA, but it just doesn't seem to be working correctly. Process flow - 1) Filter out/ Remove 'Customer Pick-up' in Carrier_ Name column 2) Filter 'Origin' to Dallas, TX, Fort Worth, TX and Arlington...

Hello - I have a spread sheet that has multiple carriers, metallics and rates. I'm looking to find the lowest carrier among bronze rates. The following formula works, however, I'm wondering if there is a way to write it w/out using { } as it is giving our API issues. Current formula...

Hello - I have a spread sheet that has multiple carriers, metallics and rates. I'm looking to find the lowest carrier among bronze rates. <tbody> Aetna BCBS Health Net Dean Geisinger Bronze 10 N/A 100 35 5 Bronze Plus 15 N/A 50 45 10 Gold 20 N/A 75 55 15...

Hello - I'm looking to find the lowest carrier based on a certain criteria. Hoping someone can help. Cell C56 gives me my rating bands 1-22 If C56 is NOT 7 or 15 I need to find the lowest silver rate among Aetna, BCBS or United F55:O55 is the row that list all my carriers F56:O59 are my rates...

Hi - I'm wondering if someone can help me out. I have a table that has carrier name and below the name is the various prices. Some carriers will have "N/A" if they do not service certain regions. I'm trying to find a way that will review all the rates and provide to me the carrier name that...