Search results

Beautiful.. that works

Chergh This is a start of what I was looking for, but i have modified the file (attached). What if i wanted to populate the result of the filtered line from the fourth column into another spreadsheet, and perform a calculation on that result? to clarify, if user chooses 1st, 2nd, and 3rd mix...

Dear all i regularly use a pricing sheet like the attached. The user must filter from left to right in the columns to get a unique row. From that unique row, there are several pricing rates which, when multiplied by the weight of a shipment will produce some pricing fees: pickup charge...

guess I meant drop down list...

Dear all I have an challenge that I believe that I can work through for the most part, but there are some things I dont know how to do: We are in need of a price calculation sheet, a very simplified example is attached. In reality, the pricing tab has many columns and thousand of records...

not to be a pest, so it should look like this: NETWORKDAYS(A2,B2)+ROUND(((B2-A2)-NETWORKDAYS(A2,B2))/2,0)-1 if so, then that doesnt work with 7-30 to 8-1 (which should be 2, but results in 1). Someone suggested: =(NETWORKDAYS(A2,B2)-1)+INT((WEEKDAY(A2)+B2-A2)/7) Which seems to work, what do...

anomoly in the above formula Hi Shades I was looking at this in detail and found one example where it doesnt work PKD -8/31/07 DLV - 10/24/07 I count 46 days, and yet the formula results in 47 days... can you figure out the reason, im totally baffled.

Cell A2 is Picked Date Cell B2 is Delivered Date The formula for C2 should show the value between the 2 dates, inclusive of weekends(valued at 1 day) and minus the Picked Date. Delivered Date minus Picked Date gives a value. That value must have 1 subtracted from it(because the Picked Date is...

Hello all Working in transportation, and I have a customer who judges our transit time performance as: Date of Pickup = 0 Weekends count as 1 day so, when calculating in excel between 2 dates, i need a formula that will return a value of each date between pickup date and deliver date(minus 1...