Search results

perfect, Thanks, works a treat

I have team data that I need to show a breakdown, so using a pivot table. However, when I show the data it looks like it is only round what is left if the days (Part days and excluding the whole days) if someone has done 75 hours doing something I need it to show 75:00 for example, I now that...

Thanks Both Really Appriciate your help :)

That formular will not copy and paste in comes up with an error

It nearly works, If there are 1 or 2 colums populated that have the same value it says mismatch if 3 or 4 colums thhe same works perfectly I enclose the live working file for you to have a look at Really appriciateyou looking at this Sean

I have a spread sheet of some 15000 products and in columns D, E, F, G I have the selling prices of 4 different locations. They should all be identical I just want a simple way / formular to show that either everything is the same or there is a difference however if a site does not sell anything...

I have various forms that I am going to give to clients to fill in. One section they will fill in is the Date they complete, and send to us. Based on this date, it will determin how many days we have to complete the work. I have a formatted the cell with this format, "dddd dd mmm yy hh:mm AM/PM"...

Thanks, I left the D14 empty so you could put in yourself My customer will add in the date as the submit the form But I want the customer to just put in the date, I can't be expecting a customer to put in the Time, any quick suggestion. I will be saving as a macro enavbled form as I have VBA...

I have enclosed an example and a few notes Thanks for your help Sean

I copied it and it still seems to be the same, I changed myLaptop Computer time to 14:00 and still no difference

I am using WORKDAY.INTL to add a Number of days to a Job request to sate the expected Date it will be completed. I was wondering if there was anyway for example if a date is added say after midday that it make the +1 day into the Next day So if I use =WORKDAY.INTL(D14, 1,1,0) I want if its...

Worked Perfect Thanks

I have a spreadsheet with the selling price of 6 different sites in Colums D-J Most of the selling prices are exactly the same for each site, but I want to be able to Highlight any cell that cell where there is a difference from any other colums. Some of the products will not be priced But I...

I am importing a product list including Barcodes from one system to another. The old system padded the barcodes to 16 digits when should be 13 see two examples below the top one has 3 leading zeros when actually the barcode starts with 87 0008711000334232 5010035062978 If there a quick way...

is there an easy way to identify illegal charachters such as " ! / \ , .

Thanks worked a treat

Sorry Stupid Mistake, Any Idea why I am getting the #VALUE! when the same formula is copied down all 2500 rows

I copied the above formula the first one works a treat the second one does nothing I have taken a snap shot of some of the data

I know that is my problem, and every one could be different

I have a colum that contains the Full Product Description (A) I want the split the contents of A into B & C Take the first 12ish Charatcters and copy to B and the remainder into C However must be in whole words For example Flaked Salmon & Lemon Pot Flaked Salmon & Lemon...

Perfect Thanks much appriciated

I want to enter some text if a cell is not blank I have a massive spread sheet and there are certain fields I must fill in, so for those that have to be filled in I already use something like this..=IF($AT120="Yes","**????**", " ") I want to enter **?** in the relevant fields lets say cell...

Sorry Yes I want the Total in Column J based on the Group name in column B The example is a small example if the sheet that will have loads of sites but the group names are not static So I have another spread sheet that I want to say For Site 1 Give me the Total Wet, and the Total Dry and the...

I want to do a look up in a within a range based on the word. The entry may change so the word Wet many be in any row in a given range, but I want to report the Weekly total in column J So in this example *Wet = £2814.50

Worked perfectly, Many thanks Much appriciated