Search results

I have a big tracking spreadsheet that adds new lines to the top and copy cells but collegues keep deleting a cell because it wasn't right on the previous row I have this Formula =IF(AND(P9<>"",P9<=$B$3+7,M9<>"Yes"), "check with Barry", "") However in M9 there is NA which is returning check...

I need to be able to instantly know of a project is at risk by not receiving details within 7 days of install I have added an example In column N, I want it to show "check" if the install date in P is within the next 7 days (and gone past the date in P (if possible) of M does not say Yes I...

I have a spreadsheet that I track all the orders for one customer Each time we have an new order we have a macro that copies Row 6 and inserts a new row 6 and pastes it back in clearing the contens from the main section see Sub AddNewProject() This works fine, however counting up items in...

I should be able to work this out but failing miserably I have provided an example and a description if v (Status is In Progress) and E is (Client owned) in x (Client owned Tills) and Y (Client owned Printers put in F(Qty) otherwise it would be zero V could be Completed, Hold, Place Holder...

I have an order sheet that automatically calculates the labour days based on hardware installed so if I have 1 we can do in a ¼ day and therefore I have an order line for ¼ day and a formular =IF(D172=1, 1,0) if more than 1 we charge ½ day and the forular on ½ day is =IF(D172 >=2, 1,0) However...

I have a Workbook with 143 worksheets on it 2 worksheets are for reference ("contract Look Up" "All contracts Feb 2021" " Key" ( more of these could be added or names changed) (if it helps these have tab colours Purple from the standard row) all of the other worksheets have no tab colour at...

I might be in the wrong section, but if anyone can help it would be greatly appreciated I have a spreadsheet where each Pm will list all of the Orders they are working on To make things easier there will be one shared workbook and a tab for each PM I would like hopefully automatically, or by...

I have a spreadsheet that is produced every month and I need to add up the total time per team member per type so I can show total hours spend on chargeable and foc work Example spreadsheet attached Many Thanks Sean

I have a list of Data that I want to show in a pivot table, however half the data I would like a calculation if possible I could do in the raw data but the raw data will have 1000's of rows if, Chargeable need to show as calculation of £75 per hour

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...

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"...

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...

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 " ! / \ , .

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...

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...

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

Like conditional formatting I want to highlight (change the Background colour) or a whole row based on the entry in one cell So in my date in column D I input "Live", "Complete", "Hold" If its a Live site hightlight the whole row a Red colour If on Hold then a yellow and completed Green I...

I have a spreadsheet that calculates the number of working days from a planned go live day using =Workday.intl but where there is no go live date it is showing #NUM! is there any way to hide this or can I use a better formular to not show it?

I have the spreadsheet with the following formula that works fine, however today I notice it has changed the date from yesterdays date to todays date. But it should be the date of posting not keep updating. I am sure there is a simple change but not sure what that should be...

I have a macro in a spreadsheet that deletes all on one sheet, then opens another spreadsheet, copies it and then goes back to the first sheetwhere it should then do some Vlookups and create an order based on an orer being geneterated by another system but in totally the wrong format The code I...

I have a regular export of data and I want to be able to show the hourly sales (which I have done) but I also want to show the Average over the week Also I want to sort by calandar week Mon-Sun So in example 1st march will be in 1 week but the 4-10 with be in the 2nd week and so on I have...

I have a spreadsheet full of stock items. Column C contains the Stock Item Column D contains the Cost Price There are many duplicate Stock items, but what I want to do is identify any difference in the cost price So is there a formula I can try that where Stock items match in C show any...