delivery

Evening everyone, May I please ask for some help I have the following formula that works out days between L14 (Delivery Date) and TODAY, but when the delivery date expires and runs over the formula shows "overdue" I have modified it to show how many days over but it showsa negative value, can...

my base data with assigned duplicate id <colgroup><col><col><col><col><col></colgroup><tbody> ID AREA CUSTOMER ADDRESS NUMBER 1 Delivery Area: 01 - Glasgow / Edinburgh 1139 - apple zzzz 893582 1 Delivery Area: 01 - Glasgow / Edinburgh 1139 - apple zzzz 895980 1 Delivery Area: 01 -...

Dear All, I want to check whether the delivery dates of SKUs in any Purchase Order have the same date or not. In case the delivery dates are different in any Purchase Order, the remarks should be FALSE or if the dates are same, then it should be TRUE. I am providing a sample set with desired...

Dear All, I do have a small data set across A1:C4 as follows:- <tbody> Dispatch Day Leadtime Proposed Delivery Day Thursday 7 Thusday Wednesday 4 Sunday Friday 8 Saturday </tbody> I would like to forecast the delivery day based on the Dispatch Day & the corresponding leadtime. For...

Hello Everyone, May I request for your assistance to create a formula for Column C (Delivery Status) to match Column E. <tbody> Country Fruits Delivery Status Delivery Status Country Fruit England Apple Yes Yes England Mango US Orange No Yes US Apple No Japan Orange...

Your help with sorting and identifying data in a workbook would be very much appreciated. I have a excel workbook that has a part number in column H and a delivery date in column K. There are multiple records (rows) with the same part number and potentially different delivery dates. I would...

Hi All New to this forum so not sure if it's the correct place to get help creating a spreadsheet. I tried an excel freelancer but they couldn't seem to make the calculations work proportionately. It's simple to do on paper but creating a formula seems to be more difficult. I'm not an expert on...

Hi, I have a set of data - example below - which I need sorting to show each day there is a delivery in the same postcode all on the same line; Data set example - <tbody> Postcode Route Drop Delivery Day AB12 3ZG <tbody> N3700 </tbody> 25 Wednesday AB12 3ZG <tbody> N3700 </tbody> 25...

Hi all, I am looking to add a warning light on my data to show which rows of data when it will be nearing the expected dates I would like an yellow indicator if it is within 5 days of the delivery date, orange within 3 days, green within 1 day and red if it goes over the delivery date I have...

Hi all, I have a very simple spread sheet I have to look at daily and I wondered if anyone might be able to help me with a formula or macro which can save me endless hours working things out? Basically, I have a stock report which I am looking to create a line of balance for. A1 - TODAYS DATE...

Hi, We have a spreadsheet we use to route our drivers deliveries, however as this is derived from a 3rd party piece of software, it does not work exactly as we want. Basically, the drivers get 4 minutes to do each delivery, however if the same customer has 2 orders, it gives them 8 minutes...

Greetings, I have been using this userform and code for several months without issue, but today I added a couple of textboxes to my userform to pass data to a different sheet; and now I am having issues with the new textboxes. The original code passed the userform data to one sheet -"wafer...

I have a large spreadsheet. column A has sequential list of dates 2005 - current date. Column G has entries for delivery (numerical amount) on the actual delivery date (corresponding with Column A). I would like to determine the average number of days/weeks between deliveries. All cells in...

Hi all, I have over 500 spreadsheets which isnt formatted in the same way, I need to only capture the below column headers and associated data which can be in a row or column. URN Packaging Delivery Price I need to capture the data in the below format to build a database: <tbody> Urn...

Hello, I have data in Column A to B. Column A="Unit Number" , Column B = "Delivery Name" and Column C = "Postcode". The Issue I have, the titles of each of the columns are in the data set. <tbody> Unit Number Delivery Name Postcode 2234we Home JK34 4FG <tbody>...

Hi all, Ive managed to get work worksheet to only calculate a cell if text is added. This allows me to plot a suppliers delivery and only consider it once I add "- arrived " EG below A1 = 1000 B1 ( =A1 ) = 0 When delivery arrives A1 = "1000 arrived" B1 NOW RETURNS = 1000 As soon as I add...

I want to work out a formula that can read a quantity from one cell and work out delievery costs for the items dependant upon the number in that cell providing a dicount for certain numbers: 1 item = 80 2-5 = 50 5-10 = 30 10+ = manual price required. help?