Search results

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

Brilliant - Thanks that really helpful One hopefully quick one - any way how I can either not show the 00/01/1900 date in column Q or format so it can't be seen, Its based on the same formula as the rest but based on the start date. Tried conditional formatting but that doesn't seems to work

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?

Please see copy of File What I want is if a reference number is added in to column E then add the current date into Column H But never update the Date in H once added ( This is the date of Posting)

So how can I change the formula to put in the date in once and once only

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 tried both of your suggestions but on both I get a Compile Error: Viarable not Defined on the xlPasteAsValues part

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

Faseeh This still gives me average tranaction not average / hour Udated version is Filtered by site Shows the hours Average / transaction Is it possible to make it show average per Hour/ over the week ie 58.65 57.80 76.60 91.25 46.85 ------ 66.23 not 2.85...

I have added the week number - Great I have managed to add a subtotal, and average it but this gives me an average per transaction, not average per hour Sean

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

Sorry, I missed that step Not something I have used before So I have re-enterd the formula and the pressed the CTRL SHIFT ENTER which has put the {} arround it It has changed the outcome but is showing a lot of wrong results. Where some are identical they are showing False Have I still do...

I Tried your formular but it came back as True on every field. Below is a link to a copy in my dropbox https://www.dropbox.com/s/tt6d97rpmi91ych/Check%20Cost%20Price.xlsx Sean

The spreadsheet is an extract from a SQL report showing all the items sold and the cost price that has been set at each store. As each site operates a contract price the cost price should be idenitical at each site. However there has been human intervention and things have been incorrectly set...

Narayan In this instance in column C there will be about 10 identical copies of each stock item, and hopefully in column D the cost price should be identical for each row. What I am wanting to do is show where there is a difference so that we can identify which store the cost price is...

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

Thanks that worked a treat

That is great and worked smashing Many thanks for your help, Sorry for the late thanks Sean

I have a excel spreadsheet with 34,000 rows I have 1 column that has a date in the format dd mmm yyyy which has given me what I want except the pre 1900 dates if a date is 01 Jan 1921 then you can see it is 01 if a date is 1 Jan 1820 then you can see it is 1 not 01 what I want to do is...

That's absolutley fabulous. the only other way was doing it manually and in the 11th hour a saviour, I was going to have to let someone down Many thanks

I have a spreadsheet with some 30,000 rows and there is a column C with dates typed in they show like this for example23 January 1920, 26 January 1915, 05 November 1909, 09 January 1911 but mainly are entered in format like 23/01/1920, 26/01/1915, 05/11/1909 I need to take this date and...

Is there any way you know to convert the dates into that format, other than manually go through them. The 1900's are ok, but the 1800 will not convert. also if I manually convert then I can't get them to sort correctly. The 1900 sort but not the 1800's see below using these as an example...

Copy of data Please note I am not a wiredo - it is a transcrip of a register for the local family history society https://www.dropbox.com/s/91cgg8vf9rkph9q/Copy%20of%20health%20authority%20Death%20Registers%20inputting%20%20formulas%20sean.xls?m What I am wanting to do is to sort the data...

I need to sort 34,000 enteries in assending order, but eavh time I do it it sorts all the 1900 dates then the 1800 dates I have also created a sort coulmn that has a date in the format yyyymmdd but that doen't work either can annyone help

Brilliant many thanks