|
|
TODAY() by
JakeyIE
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...
|
December 30th, 2003 11:41 AM
by JakeyIE
|
2 |
100 |
|
|
Excel xp RTD Function Dataset question? by
Marion Pope
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...
|
|
1 |
451 |
|
|
ERF by
LONG
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...
|
|
3 |
134 |
|
|
IF function complexity by
Seshadrinathan
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...
|
|
3 |
121 |
|
|
|
December 30th, 2003 03:41 PM
by GerryK
|
6 |
303 |
|
|
Macro/IF functions??? HELP URGENT!!! by
KrisB_bacon
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...
|
December 30th, 2003 04:15 PM
by Mike
|
1 |
286 |
|
|
|
|
2 |
127 |
|
|
Repeating entries by
Gary Fitz
How does one set up certain fields in a template so that
entries will be repeated across multiple worksheets for
certain cells???
|
December 30th, 2003 06:29 PM
by Connie
|
2 |
103 |
|
|
|
|
2 |
407 |
|
|
SUM Function by
Kate Taylor
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)
|
|
1 |
95 |
|
|
Turn off Formula Updating by
Kjuib
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...
|
December 30th, 2003 06:49 PM
by
|
5 |
185 |
|
|
|
|
4 |
117 |
|
|
Clear checkboxes by
Jaime Andersen
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...
|
December 30th, 2003 07:29 PM
by Paul B
|
1 |
444 |
|
|
Name Rotation by
MykScot
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...
|
December 30th, 2003 08:33 PM
by MykScot
|
0 |
118 |
|
|
Converting Number to Formulas by
John Kiser
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 ...
|
|
2 |
191 |
|
|
Sorting by more than 3 columns by
Jac
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...
|
December 30th, 2003 09:52 PM
by Bill
|
2 |
330 |
|
|
Challenge - Please Help! by
couger77
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...
|
|
5 |
153 |
|
|
INDIRECT formula question by
wardcanoe
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=...
|
|
2 |
439 |
|
|
if and isblank function by
Dominique Feteau
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...
|
|
7 |
131 |
|
|
IF function with dates by
Scott
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...
|
|
1 |
115 |