Functions

Replace Cells with Column names in functions?
I have a # of fairly long/complex cell functions that get hard to debug because there are also a lot of rows. Is there anyway to change display so it replaces the column name e.g. If(BT1204="X". BA="Y" to If(CustomerName="X", CustomerCode="Y") ? ... 17 Mar 2010 21:13

How to return to the previous active sheet after hyperlink?
I have many sheets have hyperlinked into 1 common worksheet. How can I return back to the original sheet after click the hyperlink and navigated to the common work sheet? Thanks for advise! ... 20 Mar 2010 23:17

i can't get this formula to work
i'm trying to write a formula where if the cell below it minus the active cell is -21< x > -23 then write one, else leave it blank. so here's what i got so far, i think i'm just getting the parentheses wrong =if((AND((c2-c1)*24)<-21,((c2-c1)*24)>-23),1,"") i tried writing a simpler formula along the same lin... 17 Mar 2010 11:23

How do I recover the autosaved file?
I closed a file I had been working on for a while, without saving. Can I recover that altered file? ... 17 Mar 2010 14:47

How to replace formula with its result
Hello Everyone, I am using a function to calculate stock levels. For example =2*BR5. But what I want is the cell to display the answer once it has been calculated, to give me an absolute answer. So if I change the number in BR5 to results do not change. Thanks in advance. John ... 17 Mar 2010 06:54

How do you search within a document?
I am woundering how you search with in a saved document. I want to make a spread sheet for my buisness on my supplies, my cost, and my mark up cost but there is over 200 so I was woundering how i can go into this saved document and just type in the item I am looking for and have it pop up with out having to scr... 17 Mar 2010 14:47

Help needed with a formula for dates in excel 2007
I need help with a formula for dates in excel 2007 If Pay Date is from the 1st to the 15th of the month then Remit Date would be the 25th of the same month. If Pay Date is after the 15th, the Remit Date would be the 10th of the following month. a1= Pay Date b1=Remit Date 01-04-10 01-25-10 01-18-10 02-10... 17 Mar 2010 11:23

Summing a crosstab
Is there a way to do a sumif on a crosstab? For example: Issue Year Duration 2,004 2,005 2,006 2,007 2,008 2,009 0 453 - - - - 505 1 - - 789 498 - 2 650 - - - 3 5,496 1,086 2,210 4 - 6,241 5 13,664 I want ... 18 Mar 2010 04:51

don't want to have to change font in header and footer each time?
... 16 Mar 2010 17:26

SUMIF with multiple criteria
Hi, I need help to SUMIF, subject to several criteria being met. Here is the setup: 1. I need a formula for cell BB24. The header (cell BB23 contains the word; Jan) 2. To the left of cell BB24 is BA24, which contains the phrase; Pay Slip. 3. Now we go to worksheet called; YEARNow. Column B9:B100 contains ... 16 Mar 2010 22:07