Functions

can't save changes to workbook; ready only
We use and Microsoft Excel Workbook as our database and I am the primary person that makes changes and those changes are saved on the other two people's copies who work in the office. This morning when I tried to save changes it would not let me and changed my copy and their copies of the workbook to a [read o... 19 Jan 2010 14:41

if(iserror()) question
Hello, I'm trying to design a formula that returns a (blank) if a formula returns an error OR a zero. The formula is of this type: =if(or(iserror(getpivotdata(.....),getpivotdata(.....)=0),"",getpivotdata(.....)) This formula continually returns #REF for errors but works properly on the "zero condition". I ... 19 Jan 2010 11:17

When entering formula it does not show the value but the formula
We received a file and are trying to sum columns but when the person enters the formula the formula stays visible but not the actual value. I've never run across this before. ... 19 Jan 2010 10:10

TITLE FOR A ROW GROUP
I have a table with similar categories in a colum I need report showing the category as a title in the row and do not repeat the category every row. I just wanted in the title of the category group I did groud and everything is ok but is ahosing the category every row. I just want to show the category as a tit... 16 Jan 2010 21:38

auto preenchimento validação
Como faço pra autocompletar célula q já tem validação de dados por lista... se eu digitar por exemplo rel ele busca na lista relógio e já auto colpleta e se eu por acaso for a janela da lista vai pra ordem rel devido a ordem alfabetica ... 16 Jan 2010 13:56

Formula Question
Hi. My data table looks like this - located in D1:E8 Stock Condition IBM TRUE IBM TRUE IBM FALSE IBM TRUE IBM FALSE GOOG TRUE GOOG TRUE I am trying to find a formula (B2) for this table - located in A1:B2 IBM Match #1 60% Where the formula in B2 looks at my data table, finds rows that have the ... 15 Jan 2010 19:27

If
Hi, =if(A1>0,1,"") "Trace" wrote: How do I get a return of 1 in column B for all numbers in column A that are greater than 0? ... 15 Jan 2010 10:29

=COUNTIF(B2:B4,"w")&" wins, "&COUNTIF(B2:B4,"l")&"
Let?s say one teams current form is: wwwddll With this formula, the result is: 3 wins 2 draws 2 losses But what I want it to say it?s just the latest streak.. in this example it would be 2 losses. And if this team wins the next game, it sould change the result to 1 win.. Regards, RG Stefi wrote: =COU... 15 Jan 2010 14:58

If
=If(A1>0,1,"") Copy down as needed. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Trace" wrote: How do I get a return of 1 in column B for all numbers in column A that are greater than 0? ... 15 Jan 2010 10:29

Excel basic quiz
Question 3 on the Excel basic quiz did any see a problem there ... 16 Jan 2010 18:21