It has been a long time since I asked this question to this problem. The answer was simple but I forgot what it was. I have a template spreadsheet I created...

I Need to Force single instances of excel, Don't have a clue but the folks here are killing me with this stuff. We had a shortcut with a /p switch to try it...

does anyone know if you can refer to more than one array in a single Excel statement? I can't find any references in Excel help or textbooks saying I...

Fairly large Excel Workbook has 60 Sheets, 10Meg size, 1500 Rangenames. Macro (VBA) adds a sheet backgound when entering a sheet, if sheetname.gif exists in...

I am running a program with information that changes several times during the day. There are several rows that need to be counted, but that number changes...

Just enter in one cell "-1" , "copy" this celle, then you select your column and make a "special paste" and click "multiply" : this will multiply your column...

One way? Assume you have the names in col A, A2 downward in both Sheets1 & 2 In Sheet2 Put in...

Hi, I want to display ASP query results in DIFFERENT worksheets, can anybody help me on this Thanks in advance Mahesh

How do brackets nesting a formula affect the formula? Working on someonelese's spreadsheet found a nested series of IF statements that start and end with...

Iam using MS-Office 97 with windows 98 as the Operating System with 40 GB Hard Disk and 128 MB RAM.Iam working with the excel file which carries 58...

Hi Sure. Try this: Sub MakeYear() Dim D As Date, L As Long For L = 1 To 52 D = DateSerial(2004, 1, 1 + (L - 1) * 7) Worksheets(1).Copy...

I'd like to take product info from the excel worksheet database and link it to individual spec sheets. Basically, I want to be able to input this info once...

I have a complex workbook I'm developing where I have lists of States, Contracts and Endorsements. I've created a drop-down that will select the State. Now I...

I think it would be easier for you to use conditional formatting. Select the cell (or range) you want to format. Go to FormatConditional Formatting Select...

Interval Date of in years Finding Plus 1 year IF today Date 0.5 11/4/2002 11/4/2003 5/4/2004 Format Number 36103 36468

Interval Date of in years Finding Plus 1 year IF today Date 0.5 11/4/2002 11/4/2003 5/4/2004 Format Number 36103 36468

Here's another option for your nested if statement. I have set up this formula to give you a zero if the value is below 10 and that's why you see the zero...

That is an array-entered formula. Press CTRL-shift-enter when you are done editing it, and if your edits didn't screw it up, it'll still work :) "Mico...

Mico, It sounds like you have an array formula. With these, you don't type the { }, Excel adds them when you enter with Ctrl-Shift-Enter, rather than...

Hi, i am trying to create a formula that has the What If Function (maybe?). So I am strugling with trying to link a single cell to import data from another...