General

Subtotals in Excel
Hi Everyone, im stuck.... im doing my NVQ Level 3 in IT and one of the things i have forgotten is the subtotals function i've set it all up correct but it is for numbers not text and i have forgotten which letter to put and where it goes i thought it was A but either im putting it in the wrong place or its the ... 21 Apr 2010 10:31

Arrow Keys
my arrow keys (up down right left) decieded not work only in Excel. What did I turn off? ... 21 Apr 2010 10:31

defaulting to Euros
Somehow my excel file defaults to formatting numbers in Euros how do i change that in 2007? when i first started everything was just entered as a regular number...but now when i enter a number it formatts it as the Euro currency ... 21 Apr 2010 12:35

When I search this group w/my user name nothing from 2010 comesup
The web interface for this newsgroup doesn't work so well. You could access the newsgroup directly using a newsreader instead at this address news://msnews.microsoft.com/microsoft.public.excel.misc Meenie wrote: Why aren't 2010 questions coming up in search? ... 21 Apr 2010 09:28

Can an If statement return a formula for false?
Help... =IF(I3="Closed","Closed",D3-$D$1) Column I = Open or Closed D1 = =TODAY() The rest of column D = =DATE(YEAR(C3),MONTH(C3)+6,DAY(C3)) Can you return a formula in an IF statement as i get a circular ref Thanks Andy -- mellors ... 21 Apr 2010 10:31

Conditional Format
Hello, I would like to set a conditional format to color each unique value a different color. It will also be applied to multiple occurences of the value. The problem is that the values are dynamic and may not always be the same number of occurences, in the same cell, etc. I have used the formula IF(ISNUMBER... 21 Apr 2010 12:35

Lookup formula
Hi, I have a lookup that is looking at 2 different worksheet and the formula is =IF(ISERROR(IF($D1="ruth baybutt",HLOOKUP(A$3,ruth baybut!F:N,3,0),HLOOKUP(A$3,sheet2!F:N,3,0))),0,IF($D1="ruth baybutt",HLOOKUP(A$3,ruth baybut!F:N,3,0),HLOOKUP(A$3,sheet2!F:N,3,0))) So the formula is asking if cell D1 = Ruth ... 21 Apr 2010 09:28

charts with percentages
I have made a chart in word with percentages in a data label, when I change my figures in my excel worksheet it changes the pie chart shape, but not the percentage. How do you either refresh or update the information? ... 21 Apr 2010 09:28

When I search this group w/my user name nothing from 2010 comes up
Why aren't 2010 questions coming up in search? ... 21 Apr 2010 12:35

need a formula to find "*" in s string and multiply by preceding and following values
Hi Tonso You could also create a named Formula Insert>name>define Name Result Refers to =EVALUATE(RIGHT(A1,9)) Now in any cell to the right of your string of data, enter =Result and copy down -- Regards Roger Govier Tonso wrote: On Apr 19, 6:16 pm, "T. Valko" <biffinp...(a)comcast.net> wrote: Im... 21 Apr 2010 09:28