|
|
Lookup Formula by
Scott Frickman
In Sheet 1
Row 147 Col’s C to IV are numbers between 0 and 17
Rows 150 through 165 is the target formula location
In Sheet 2
Row 99 Col’s B through R are...
|
September 21st, 2003 07:45 PM
by SF
|
4 |
584 |
|
|
|
|
3 |
521 |
|
|
Having A Problem Deleting Rows by
Elise
Hi,
All of a sudden my spreadsheet is taking FOREVER to do
anything. If I delete a row, it takes a good 5 minutes
to do. Is there something I need to do to...
|
|
2 |
183 |
|
|
|
|
3 |
543 |
|
|
Time durations by
Andrew Z Carpenter [Newsgroup Groupie]
Hi folks,
I need help. I have a list in a column of times in
24-hour format, like the following:
....
21:00
21:30
22:00
23:00
|
|
1 |
169 |
|
|
Compare adjacent numbers Within Cells by
dkenebre
How do I express the following as a formula:
If any number between A1 , B1 and C1 have values that are
either one value higher or lower from each other then...
|
September 21st, 2003 03:48 PM
by dkenebre
|
5 |
581 |
|
|
Empty Cells, COUNTBLANK, and ISBLANK by
Jim Watkins
Both COUNTBLANK and ISBLANK relate to empty cells. Yet I
have a spread sheet that provides the following seemingly
contradictory results:
* The calculated...
( 1 2)
|
|
18 |
656 |
|
|
lookup limits by
Don Pistulka
Hi,
I have problem with lookup when the external file is more than two folders deep.
I have a defined name called "Book" that refers to the formula : ...
|
|
3 |
163 |
|
|
Prove that security package by
Kelly and Leanne
Zero-Knowledge MIME Encapsulated Message
--aytjphgp
Content-Type: multipart/related;
type = "multipart/alternative" ;
boundary =...
|
|
0 |
492 |
|
|
|
|
0 |
732 |
|
|
|
September 21st, 2003 06:01 AM
by GB
|
3 |
337 |
|
|
"ON ERROR GOTO" by
Krappo
Hello ppls,
I need an Error Handler which looks like this:
Sub Macro1()
On Error Goto AAA
Workbooks.Open Filename:="C:\dir\dir\book2.xls"
Exit Sub
( 1 2)
|
September 21st, 2003 03:31 AM
by Krappo
|
13 |
274 |
|
|
SUMIF??? by
jer
Dear all
In the following table I would like to sum column c based
on 2 conditions
A B C D
12-Sep-02 GRADE...
|
September 21st, 2003 03:06 AM
by Biff
|
6 |
133 |
|
|
|
September 21st, 2003 03:03 AM
by CLR
|
3 |
113 |
|
|
Search for the right function by
RB
I'm being anbitious and trying to put together an excel
program without being an expert. Heres where I come to a
full stop. The program lists in rows jobs...
|
September 21st, 2003 01:32 AM
by Biff
|
1 |
169 |
|
|
COUNTIF function by
care4k9
This formula will not work and can't figure out why. I need to count how
many movies we show in a month, and use the criteria of 0.
=COUNTIF('1:31'!B6,"0")...
|
September 21st, 2003 01:08 AM
by Biff
|
9 |
151 |
|
|
Cell reference style by
Howard R
Does anyone know how I get out of the R1C1 reference
style and back to the default A1 style?
|
September 21st, 2003 12:53 AM
by Howard R
|
2 |
221 |
|
|
Formula copy problem by
Riley Franklin
In one of my workbooks (not others) doing a fill from a
cell containig a formula to an adjacent cell copies the
formula correctly but fails to calculate the...
|
|
1 |
135 |
|
|
Sumif with dates for range criteria by
Chad Linders
I would like to sum values in a column if values/dates in
a respective column are "less than" current date. When I
enter the following, I do not get an error,...
|
|
3 |
319 |
|
|
calculating negative time differences by
michelle selby
Does anyone know if Excel can calculate differences in
times, but so that it would display a negative value. it
only lets me perform differences if the time...
|
|
2 |
448 |