Search results

have error on that pal

Hi i have a simple spreadsheet attached that shows depart time and a trigger time that is 2 hours prior, this should feed a simple if statement to show if escalation is required i cannot make it work any help would be appreciated, i think it has something to do with the NOW () function being day...

Hi i am trying to insert a simple calculated field i have a count of products and a sum of products i want to find the avg both update qty are from the same field thanks if you can help

sorry Hui's explination your way is excellent again thanks

not sure about this ? can you explain please

thank you 50 karma points going to you

I have a problem with trying to work out a complex sum if some body pick 25 items in 1 hour 25 minutes and of that 16 min are waste time.. how many would he have picked had the waste time been removed. i am producing a time and motion study and i am stumped i have attached a real example...

Thanks for the speedy replays the min max function in the pivot is great thanks again

Good afternoon I have a long list of users that I need to extract daily there first scan and last scan time from a list sounds simple but I don't know where to start I can use pivot tables etc but this has baffled me, I have attached a sample file

Hi Chihiro thanks i have created a macro that will select the columns and convert text to columns Hi Vletm the code didn't work for me all it did was insert§ between 12-Feb-20016§13:00. could i use a relationship using order id to look at both tables? once the date is sorted

Hi thanks for your quick reply it would appear that they are in some sort of a date form i have added a sample file the yellow columns are vlookups to the order number this file gets rather big as you can imagine.

I have a large dataset that is taken from a warehouse management system unfortunately the dates are not friendly 20-Feb-2016 11:27:10 so when i use a pivot it cannot group on the dates? i tried doing ctr+f and replace all the - but this did not work and taked forever with 100,000 rows of data...

Thank you very much this made it really easy to adapt thanks Karma to you

Hi Luke No its a simple select if the check was good its green if it was minor its orange and if there was a safety related its red the colours are simply pasted in thanks

Hi i am trying to count text within a spreadsheet but with 3 different colours i have managed to count total cells with the text but this needs to broken down to 3 colours. i do have some VBA that looks at the colours. please see below any help is appreciated thanks

i did it what do you think

now i have a little bit more of a problem with if its under 30 MIN or between 30-60 MIN or over ? <30 MIN +30 MIN +60 MIN 1 1 0 i tried where i3 is late time its the between 30 /60 is the problem i will upload my file

thank you very muck i can see now its quite easy regards

I have a sheet relating to timed delivery's and i am having trouble with past midnight and is it within 30 mins or 60 mins i have put a basic example i appreciate any help thanks

Good afternoon, i have been playing around with macros trying to achieve my goal but i am struggling. i have an TM Export Data sheet that i need to import once a day to into Customer Book to create collection and delivery's, i thought i was doing OK until l noticed that some collections have...

Thank you Narayan you are a legend you are most helpfull

Good morning i am trying to remover numbers from an export data sheet Column B Name 1. Carl Ritson 2. Paul Smith 123. Dave Anderson It should be Column B Name Carl Ritson Paul Smith Dave Anderson i have tried using trim but the placing for that week could be from first place 1. to next...

thanks for the replys my work around was to save the exel book as a template then it always produced a sheet 1 every time you open it and try and save. it could be that i did not explain my problem fully i will upload a sample the proccess goes like this open macro work book copy data from...

Hi i have created a macro the inserts a pivot and set the fields and values but excel creats a new sheet and the number goes up by 1 ie sheet 1 next is sheet 2 but my macro looks for sheet1

that's perfect my i take this opportunity to thank you for your help