Is there a way to make the TODAY() value stick once it is populated. For instance, I want yesterday's date to stay as yesterday's date and not change to...

Is it possible to pass an array of data through a topic in the RTD function? I would like to pass a dataset or array from a .net RTD Server and fill in the...

I have problem in doing the function ERF for -100.I know that in the help menu,it has specified that it cannot over come the problem,but i hope that i can...

I am an advanced user of Excel. I have a complex IF Function which uses GETPIVOTDATA functions that can return #NA or #REF values. I want to trap the error...

Is it possible to see the "last saved" date and hour of a file in a cell of the worksheet of the file. I try to find a solution for a long time without...

I'm at school, doing an Excel project on a School Geography Departments accounts for my coursework, I am a intermediate Excel user. In 1 worksheet, I have a...

Dear all can a VBA procedure access a range values in a workbook that is not open? Million Thanks Eric

How does one set up certain fields in a template so that entries will be repeated across multiple worksheets for certain cells???

I have a text string that contains an age range...: text_string(1)= 6 - 10 text_string(2) = 11 - 13 text_string(3) = 14 + I also have an age variable...

In a Excel spreadsheet, is the SUM function only for adding numbers or can it be properly used to create formulas, i.e. =SUM(I23*H23)

I have a formula that calls for a range of cells. but when I delete a row from this range, it changes the formula to calibrate for this change. How do I get...

The formula maker rejects the above formula, and wont accept any variation. It also insists on converting it into alpha numeric date. I I used...

Hi, I have numerous check boxes in a worksheet that I would like to clear automatically by running a macro. I already have a macro set up to clear some other...

i have searched the internet extensively for a formula/function that will work in Excel (2002) for my dilemma. i run a Euchre tournament weekly and i need...

I have a very long list of numbers that I want to convert to formulas in their current position. Example: A B C D 1 16 2 22 4 3 ...

Is there anyway to sort by more than 3 columns in Excel 2002? I keep having to sort by the max 3 columns and then run a subsort. Has anyone found a trick to...

I need to return a value in J3:J25 on sheet (DATA) The value being any of the following A through L or BOE(U), BOE(NU), GE, etc... as represented on sheet...

I have used the INDIRECT formula many times on a particular spreadsheet. ie B1: D A1=2 C1= INDIRECT(B1&A1) A2=2 C2= INDIRECT(B1&A2) A3=3 C3=...

Heres is my function: =IF(ISBLANK(L16),"","Cc: "&L16&" "&M16) What i want to do is put L16 & M16 together with the "Cc: " in front of it. But I want the...

Hello everyone, I'm having some problems with a formula that should be simple so I'm hoping someone can help me out. What I'm trying to do in cell B2 is have...