Search results for query: *

When a worksheet is protected, how can I ensure that a user can still amend row height?

Why,when a series of worksheets within on workbook are protected, the user cannot navigate easily across tabs using ctrl + page Up/ page down? How can this be avoided?

I've created a workbook, certain tabs of which will be printed for presentation purposes. All page set up options have been set up - Print area, fit to page 1 by 1. However, when the page prints, there is sometimes lots of wasted white space - Is there any way to 'stretch' the page to the...

Hello, Does anyone know of a way of moving microsoft word pages to another document. Something similar to the function in excel or powerpoint. TIA mark

Hello, Can anyone tell why this formula is just returning #value =SUMPRODUCT((('Iflex Projects Summary'!$C$6:$K$102=Iflex!$C$14)*('Iflex Projects Summary'!$D$6:$K$102=Iflex!$M$11)*('Iflex Projects Summary'!$C$6:$K$102=Iflex!M12)*'Iflex Projects Summary'!C6:K102)) I'm trying to use sumproduct...

Hello, I am using this formula =SUMPRODUCT(($B$14:$B$16=$B$5)*($C$13:$F$13=C4)*$C$14:$F$16) In the below summay table which returns the sum of the criteria in Data Source A B5 = the Cost Code 1 and C4 = Company A and C14:F16 is the table Data Source B Criteria is that Cost Code and...

Evening all, I have a row with headers of company names I have a corresponding column of cost codes that are charged by these companies. I need to produce a summary table for all departments. I've done this using sumif formula but it is messy as I need to get the row headers to be in-line...

I've had this issue with excel for some time and can't figure it out, any help appreciated. Issue: Cell b1 there is a formula =month(a1) This returns 1 for Jan which is fine and correct Cell c1, there is a column that has dates in it but is not formatted correctly, so I have a formula that...

Morning, Having trouble working out an if formula, trying to find out if cells a1, a2, and a3 all contain the same values, e.g. that all have the number 5 in each cell, then return yes or no. any ideas? tia

Hello, Pretty new to Powerpoint. I have a object which is a circle on a powerpoint slide. Is it possible to make the circle spin in circles for around 5 seconds? I've tried custom animation and i'm using PP 2000, does anyone know how to work it? Thanks, Mark

Hello All, Some help please: I have a Master File that contains a list of the headcount on board for the department. This Master File is linked to other files that the manager's maintain and update with their individual headcount details. Is there a way, that if one of the linked files has a...

Afternoon, Does anyone know how to link the background of a powerpoint slide (e.g. pictures of clouds) to excel and still be able to type within the cells? I don't think it is possible. Thanks, Mark

Evening and happy new year, I have a range of cells (H2:L2) There are various numbers with these cells. In cell M2, I've been trying an if formula to help with following but can't figure it for the life of me.... If within the range of H2:L2, the number 35 or 40 appears 3 or MORE times then...

Hello, I have a column with dates that either end as yy or yyyy. For example: 09/27/04 07/07/2003 What I am trying to do is delete any rows where the date is ends in 2003 or 03. I have tried a custom filter and text to columns but it's not working? Any ideas welcomed and appreciated. TIA, Mark

I am using an IF statment below (with the thanks of this site) =IF(AND(AH75="PP Review",I75="",I85="Y"),1,"") Is there a way to include the Interior Colour as a additional criteria? For example, if it passes the above conditions PLUS the fact the cell I95 has an Interior colour of Red, then...

Afternoon, I have three columns that if they all match this criteria: Cell 1= PP Review Cell 2= isblank Cell 3= Y Then return the value 1, unless ALL match their criteria, return a blank value "". I am trying this with the below if(and formula and it won't work. Really fustrating...

Morning, I have the below formula in a cell, basically an if(and) formula with 7 scenarios. I want to add on another 6 scenarios within the same formula e.g. 60%-80%, 80%-100% etc. When I add in more arguments I get the message that there is an error in the formula. Is there a limit in the...

Hello, I have a list of references e.g. 200218561, that are in column C, they go down to row 80 and are individual. I need to retreive exactly 26 random references for sampling purposes. I've tried rand but can't figure it. Any ideas? As usual, TIA, Mark

Does anyone know why excel does not add values in a cell sometimes? For example, I have a row with the below values 0.2 0.5 10 12.6 And when I try to sum it returns a vaule of zero? Any ideas?? TIA,

Hello, I'm trying to delete rows where there are duplicates. I've tried advance filter and it doesn't seem to work for my problem. Basically issue is: Columns A through I contain data down to row 50, I then add in this weeks data which contains last weeks and this weeks data under row 50. The...