First

Prev 
Next

Last
Pages: 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227
#NAME? Error With User Defined Functions Excel 2007 I have a problem that has been driving me nuts. I created a code module and have pasted a couple of user defined functions into the module. When I am entering my formula into a cell and I start typing the name of the function, I see that the function is listed in the dropdown list of functions. ... 6 Jan 2010 09:49
Countif Formula I imagine this is a simple question, but I would like to do something like the formula below, but I would like to do it for a range within 15 minutes (+15 or 15 of 0). =COUNTIF('Data (2)'!$Y$2:$Y$1508,">30") Thanks ... 29 Dec 2009 18:38
Product Formula Hi, I have a column of quarterly returns which I wish to calculate longer term returns from. My problem is that the list will continue to expand over time (I will insert a row at the bottom every quarter) and the calculations should always be over the latest periods (e.g. 1 year/3 year etc). I have tried u... 29 Dec 2009 11:56
Error with Copy function Hi, I'm trying to copy data from workbook A to workbook B. However, whenever I select workbook B, the Paste function is blur, which means I can not paste it. If I create a new workbook , then I can paste the data there. In workbook B, I created a macro to open workbook A. Pls help me how to fix this. Ma... 29 Dec 2009 07:30
formula for excel sheet. Hi, I want to use a formula in excel as below described. i want a formula value in Cell A2.b In Cell A1 is value say if it is $ 500 or above then the A2 should be 75% of A1, if A2 is between 200 to 500 then A2 should be 50%, if A1 is below 200 then A2 should be 25% of A1, so please help me out  thanks in ... 29 Dec 2009 10:49
In Excel can sheet tabs be placed along a side margin? Instead of having tables along the bottom of a sheet, I want to put them down the right hand margin. Is this possible in Excel? ... 29 Dec 2009 06:26
hello please help i really should have payed more attention in class ok i want to do some book keeping. i buy and sell stuff. i want a to be what i bought like an item i want b to be what i paid to get the item i want c to be time and gas put into getting item i want d to be additional costs like repair or parts added. i want e to be totals of all expenses basically add b+c+d i w... 29 Dec 2009 01:04
Count Consecutive string of same number Hi, I would like to find a formula that will give me the largest consecutive sting of numbers out of a list. Here is an example of the list (A1:A10000): this answer is 3. A 1 1 blank 1 blank 1 1 1 Thanks! ... 28 Dec 2009 22:54
subtracting ranges In cell p94, I tried the formula =sum(d94:e94)sum(f94:o94) and it does not give me an answer in p94; can anyone help? ... 28 Dec 2009 17:24
Same problem. I've had the same problem with one of my spread sheets. The file is not protected and I can open the format cells dialog box on either side of the effected cells. I'm completely stumped as to why I cannot open the dialog box and multiple google searches have not helped. MsExlLearner wrote: Check whether th... 28 Dec 2009 12:58 