|
|
CONDITIONAL FORMATING FORMULA by
Kanmi
Heading in cell D1- POS Interview Date -- Cell D2 4/23/10 (I need this cell
to turn green 60 days prior to date.) Using conditional formating. Please
what is...
|
June 26th, 2009 05:03 PM
by Kanmi
|
6 |
90 |
|
|
VLOOKUP by
Kanmi
=VLOOKUP($B8,'WPS Detail Dates'!$B:$AT,49,FALSE) pls why is formular showing
#REF!. Please can anybody help me with this. Appreciate your time. Thanks
|
June 26th, 2009 04:36 PM
by Max
|
3 |
143 |
|
|
|
June 26th, 2009 04:28 PM
by mark
|
4 |
201 |
|
|
ACCRUED INTEREST (ACCRINT) Bug by
Keith
I used the Following Data:
Copy Paste into Cell A1:
Data Description
11/30/2008 Issue date
5/31/2009 First interest date
6/26/2009 Settlement...
|
June 26th, 2009 04:19 PM
by Keith
|
2 |
124 |
|
|
Iserror for an array by
diepvic
Hi,
can I use Iserror for an array?
like ISERROR(A2:A300)
I've tried this with a non-error array. The result is TRUE, which means
there's an error in the...
|
June 26th, 2009 03:34 PM
by diepvic
|
8 |
225 |
|
|
need complex if formula (I think) by
b4nature
In the sample below I need to be able to isolate students who have a G status
for the VERREV code and an S or W status for all of their other codes. I have...
|
June 26th, 2009 03:19 PM
by Bernd P
|
3 |
220 |
|
|
|
|
1 |
166 |
|
|
|
June 26th, 2009 01:56 PM
by Mike H
|
3 |
179 |
|
|
excel - outlines by
meghnal
Hi,
I have to copy data from one excel file to another. I am using the following
command to copy
ws2.get_Range("A1",...
|
June 26th, 2009 10:07 AM
by meghnal
|
4 |
153 |
|
|
Worksheet protection by
ssdsibes
Hi
I have protected my worksheet to stop users from chaning information, but
now the Refesh External Data does not run.
I need to unlock the worksheet to run...
|
|
1 |
111 |
|
|
|
|
3 |
145 |
|
|
Doing multiple borders by
Herb[_3_]
How to "freeze" border menu so I can do multiple borders without losing menu
each time. I think it was in 2003 Excel that by double clicking title at top
of...
|
|
1 |
106 |
|
|
Relative Worksheet references by
mjb1
Is there a way around the fact that you cannot use a relative reference for
the Worksheet?
I want to use the ending balance from June to automatically...
|
June 26th, 2009 07:19 AM
by mjb1
|
4 |
122 |
|
|
|
|
4 |
98 |
|
|
|
|
5 |
179 |
|
|
VB CODE by
Kanmi
Please can anybody help me check this code why is not working. If set of date
below change then Latest Update date on column "10" should automatically...
|
|
7 |
145 |
|
|
FAQ : Answers to show in another cell by
gwtechie72
I am trying to create a FAQ in Excel 2003, I have the list of questions, but
I am not able to have the answers show up in a different cell. For example:
if...
|
|
4 |
204 |
|
|
adding text to the end of a formula by
Lodge
Does anyone know how I can add text to the end of a formula in the same cell?
For example, the formula I have will compute a list of numbers and display
the...
|
|
1 |
98 |
|
|
|
|
3 |
88 |
|
|
|
|
1 |
178 |