Search results

wow thank you very much

Please see example The red tab is the data as i get it , i then make a pivot table green tab , drill down blue tab, then copy each driver one by one into a record of discussion orange tab i then print this off and give to the training team. i have to do this for every driver is there a way to...

Please see example The red tab is the data as i get it , i then make a pivot table green tab , drill down blue tab, then copy each driver one by one into a record of discussion orange tab i then print this off and give to the training team. i have to do this for every driver is there a way...

Thank you very much appreciated as ever

this was my attempt but it created duplicates

Good evening i have been tasked with creating a randomizer i need to select 10 trucks from a given list , the list does shrink and grow , the trucks have to be unique, i managed to make one but the truck sometimes are duplicated i have attached what i am after thanks for any help in advance

that's great thanks

ahh i have a small problem if i arrive before the hour i can still claim demurrage i just have to wait till the booking time before demurrage starts so the bit about 1 hour befor is not true only the one hour after

thanks thats great just what i was after i am trying to do this with an access database as well as its much better for reports i have managed most of it i am struggling with your last formular in access the expresion builder will not accept it

thanks that worked great ,if the driver is late or to early then demurrage is discounted.... if "on time" then demurrage starts 90 mins after booking time . i have added the spreadsheet ..sorry i thought it would have been rude to post it. yet again i am grateful and thank you for your time

first of all a big thanks for looking please see attched

hi i need to know if one of my drivers have arrived on a delivery but it must be within 1 hour of time before or after ? is this 2 if statment or a greater or less than

thanks guys i managed to use this =INDEX(data,MATCH(B7,INDEX(data,,1),0),MATCH(A7,INDEX(data,1,),0)) thanks Shrivallabha i will also persue the links as my distance chart is limited thanks thesilkster

i have a distance chart like this that has distances from post code to post code from paragon ` .....AB1 AL1 B1 BA1 BB1 BD1 BH1 BL1 AB1 0 516 426 518 326 339 568 339 AL1 516 0 97 119 206 181 115 191 B1 426 97 0 99 115 131 161 101 BA1 518 119 99 0 207 223 68 193 BB1 326 206 115 207 0 40...

Hi Guys i have a spreadsheet that has in column A postcode start and in column B postcode finish is there any way i could get the distance traveled? in column C regards any help appreciated Carl

Wow SirJB7 you are quick, many thanks for the quick feed back i will have a look Regards Thesilkster

Is it possible to extract data from and excel spreadsheet and show it on a scrolling RSS feed? please advise

Hi, I am Carl from the UK looking forward to speaking to fellow Excel users