Functions
in [Excel]
|
Average Length of Stay Column A is Funding Source: "A" or "T" Column B is Days of Stay calculated from check-out date minus check-in date. How to calculate Column C as Average Length of Stay for "A"s? ... 11 May 2010 10:04
sheet protection with links Dear all, I have a sheet that has links to another file. I would like to protect the cells with the links so that the links cannot be deleted (i.e. the formula/format of the link) and replaced by values, but would like to allow the link to be changed to the corresponding file. Is there any way to do this?... 11 May 2010 10:04
horizontal scroll bar I have a document open in xcel and I cannot figure out how to get the horizontal scroll bar to be bigger. I mean I have zoomed out to see if I have anything "out in space", but there is nothing. The problem is I have freeze panes on the first column, and if I hit the horizontal scroll over it takes me way to fa... 11 May 2010 08:57
Excel 2003 worksheet tabs missing at bottom of my laptop display How do I get multiple worksheet table to show at the bottom of my Vista laptop display? The do appear at bottom of my XP desktop display. Thanks. ... 11 May 2010 16:48
Excel auto accumulation formulas Hi hello, I need a formula for auto accumulation formula like example: John need to give me USD50 everyday for one month, so if he never paid the money i will key in 0.00 in that collumn and the ammount accmulated for today is 50.00 and the next day calculation like USD100, but if he did the payment full i ... 11 May 2010 03:33
Remove Text From AlphaNumeric Hi All, I have a colmun of Codes, of varying lengths that contains Letters at the end of each Code. The letters range from 1 single letter up to a word, again of varying lengths. I need to strip out all alpha letters and retain only the numeric numbers. Either a fomula or Macro. Many Thanks, Bam. ... 12 May 2010 01:35
Ranking from one sheet to another I'm trying to rank a particular result from one sheet to a range of results from another sheet but it is giving me an error when I do so. Here is the formula I'm using... =RANK(AD16,National!B16:B56,0) I'm not sure what would be wrong with that, unless I have to factor in another formula to indicate the ran... 10 May 2010 21:02
=SUBSTITUTE(C4,"~?#","") will this work to remove multiple string Hi All, I need to remove multiple string (special characters) in an excel field. Would the following work =SUBSTITUTE(C4,"~?#",""). I need to execte this without using Nest Function. Please help!!! Thank You ... 10 May 2010 18:48
lookup to see if multiple values exist Hi, I am faced with this problem. I have data as follows: Col1 Col2 Col3 S1 H1 Value 1 S1 H2 Value 2 S2 H1 Value 3 S2 H2 Value 3 I need to roll this data up so that I get ColR1 ColR2 S1 "Multiple" S2 Value3 Basically if S1 has multiple values the... 10 May 2010 21:02
Pivot Table from 2 worksheets I thought I read somewhere that you can create one pivot table from two worksheets. Does anyone know how to do this in Excel 2003? I need to create one and don't know how. Thanks so much. Nadine ... 11 May 2010 03:33 |