transport

Hello, I am looking for a formula that will list out all the possible transport modes horizontally to the right of Item. all the transport mode associated with the ship ID can be found on sheet 2. I need to see them all horizontally next to item in sheet 1. Please let me know if you have any...

In colum j would like the results of looking in column "D" to find duplicate transport name, then look in columns Q & R to see if the month is the same for all of the duplicates find in column d. If the months are the same leave cell blank, if months are different then the move , "crossed over"...

Hi, I am working on an excel wherein there is login and logout mentioned for employees. I am looking out for a formula which will count from row 1 all the time related cells and give me an output. For Eg. In row 2 the Pickup should be 0 and the Drop should be 1 (since there is time on 6/9/17...

Hello Ladies and Gentlemen, Just like the title says, I need some guidance with this project. I am part of a very small transport company and am trying to make a workbook that I can input parameters into and it will spit out a dollar amount that it would cost my potential customer. Below are...

Hi Guys, long time no see! My query today is to ask for help with the following: I am allocated to put through transport requests for staff at my company. All our shifts are saved onto a spreadsheet as per example below. What I need is a formula to check the shift in cell B2, compare it to a...

Hi, I got 2 sheets. (1 called "Revenue", the other "101") in the sheet revenue are department codes (variable 100 to 999) they are situated in row "B". the corresponding data in row "D". this data needs to be transported to the sheet "101" in the sheet "101" are put the numbers 100 to 999 in...