General
in [Excel]
|
how do i watermark an excel spreadsheet? office 2000, would like to have watermark behind text in spreadsheet, to appear centre page, almost full size of page. ... 28 May 2010 03:56
lookup with IF criteria I am needing to look up data from a seperate report in which the VLOOKUP formula will not work as there are multiple instances of the lookup value in such. I would like to pull in specific results. Example - below is the table_array in which I want to pull in the result where 'jim' is either "def" or "jkl", f... 28 May 2010 10:27
How do I write to a closed work book as a "register" Hi there all you Gurus out there! I have created a macro to create a unique invoice number in a work book, but for my specific purpose, each time I create a new invoice number i want to record this in a rolling register in a separate spreadsheet & workbook. If i have another spreadsheet open I found I can do this... 28 May 2010 08:15
Center All Pictures in Excel Cells Please help. Right now I have a UDF that I found online that lets me insert a picture into a cell by referencing the exact location on my hard drive where the picture resides. I also have a macro that if I select a shape # and range value, it will center that shape in the cell for which is referenced. Is there ... 28 May 2010 00:43
Where it is possible to download MSN MoneyCentral stock quotes I have a new pc for 4 weeks and I would like download MSN MoneyCentral stock quotes for Excel 2007 under Windows 7. Do you have an idea where it is possible to download this? Thank you ... 27 May 2010 22:33
Can I import text file of cash flow to excel file then use formula What I want to achieve is to scan in a cash flow (save to PDF) then copy to an excel spreadsheet and have it recognise the value of the numbers so I can use formulas. The same way you can with word. I have two entitys and I want to add their actual cash flows together to project combined cash folws for future ye... 28 May 2010 08:15
How do I keep rows a1-a2 always at top of screen when on row 50 How do I keep rows a1 and a2 always at top of screen even when I'm on row 50 or 75, etc. I know it's a simple command but can't figure it out. I have older version of Excel thanks ... 27 May 2010 21:29
averageif with 3 criteria Trying to average the results of this sumproduct formula. Searched the questions already asked but only found average if for 1 or 2 criteria SUMPRODUCT(--(S498:S534="A"),--(G498:G534>=100),--(G498:G534<=200))/SUMPRODUCT(--(S498:S534="A"),--(G498:G534<>"")) ... 27 May 2010 22:33
Additional column formula in pivot table I am a relative newbie to pivot tables. Using Excel 2003 I have, for example, 8 columns of quarterly financial data. I would like to add a 9th column to calculate the CAGR for the 8 quarters. Can that be done within the pivot table? ... 27 May 2010 20:23 |