Hello Does anyone know of a way I can create %s of subtotals in a pivot table - instead of % of grand total. I need to create a table from a cube which has...

Hi, I am trying to work out the following and would appreciate alittle help. I want to set conditional formatting so that a cell changes colour whenever A2=40...

I hope you can help. I have posted something similar to this before but got no response. I'll try again. I have name and a number in this format: cell a1...

=IF((H36)300000,E36*1.1-E36,0) The above sort of works, but you have to type in half of the total cost 600,000 I would like: IF((Current Payment)50% of...

Hi All, How can I have a formula to get % variance (+/-) without generating an error? for eg: if A1=100 and B1=150 then I shud get in C1 50% and if...

i accidentally deleted the "/e" (no quotes) that comes after the path and when i restored this a "%1" (no quotes) appears and now whenever i try to open an...

Hi, I have designed a sheet to measure staffs work times. In this sheet i put a workrate time they need to work at and in a column their times are recorded...

Help me find the %RSD formulae in the Excel spreadsheet

I have {{=COUNTIF(E5:CZ5,""&E$1:CZ$1)}&" \ "{=COUNTIF(E5:CZ5,""&E$1:CZ$1)}}, trying to combine two ARRAY statements in the same cell. I could use two...

Hello and thanks for the help. I am bringing together two cells one with the date and then a dash, the next cell has my note. I cannot seem to figure out how...

I was trying to use "and if" which wouldn't work. I then remembered "& if" which did and is much more elegant and simple to use. It took some time to come...

In multiple test logic I was trying to use "and if" but found that it wouldn't work. I then remembered "& if" which is much more elegant and simple to...

I have this formula in a cell =D12+1&" - " &D12+5 It produces this : 39528 - 39532 The cell format in the cell shows as m/dd/yy D12 = 3/20/08 I would...

I found the answer to my problem in this...

I read a thread and got lost so I decide to start my own thread. I have seen &"" quite a bit (e.g. in a COUNTIF or MATCH formula) but I have never seen &"~"...

I have and & TEXT formula that makes a statement like: Month: 5.1 Chg YTD -2.5 In the &TEXT formula, how do I format the numbers so that all negative...

Hello Everyone I am trying to do an Array Sumif formula for a discrete range. I can get it working no problem using = but not for the other side I.e. I have...

I have a spreadsheet grouped by division and region. Region is the inner group an division is the outer group Column A B C D...

I need to write a simple formula but I cannot quite understand how to do it in Excel. I need to take the value of a cell (lets call it A8). I need to subtract...

Hi, using Excel 2003. Is it possible to have a vlookup have the name of a workbook containing the range to lookup (2nd argument) in another cell? Something...