|
|
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 |
|
|
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 |
|
|
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 |
|
|
|
|
3 |
543 |
|
|
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 |
521 |
|
|
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 |
|
|
APR calculation by
amanda
Hi,
I hope someone can help me with this one. I need a=20
formula that will calculate the monthly interest if i have=20
the following data:
Loan value (=A3)...
|
|
7 |
163 |
|
|
excel by
scott
I have 500 names, addresses, phone numbers etc. How do I
set them up in Excel so they have their own line? I think
it is referred to as "comma separated" ...
|
|
1 |
129 |
|
|
|
September 22nd, 2003 03:33 AM
by Rohani
|
1 |
118 |
|
|
Interactive spreadsheet as webpage by
gp
Hi all,
Im kind of stuck with excel.
I have an excel spreadsheet created with option box,
calculations etc.
I want to save this excel sheet saved as an...
|
September 22nd, 2003 01:51 PM
by gp
|
0 |
313 |
|
|
|
|
1 |
475 |
|
|
COUNT visible cells? by
Gregg Stone
I have a filter turned on and need to COUNT only the visible cells in a
column.
Any suggestions?
Thanks in advance for your help.
|
September 22nd, 2003 03:07 PM
by Andy B
|
3 |
527 |
|
|
how? by
HOW TO CONVERT $ TO INR ? BY APPLYING A FORMULA ?
|
September 22nd, 2003 03:13 PM
by Pierre
|
2 |
148 |
|
|
vlookup by
Joseph M. Yonek
I have a table that has the values that I want to base the vlookup on in the
second column and the information that I would like to return in the first.
Is...
|
|
2 |
149 |
|
|
Last value in an unsorted table. by
Catalin
1. I have a table of around 3000 rows, incresing daily.
How can I find the last entered value 'X' in column A.
Table is not sorted by column A and the value...
|
|
3 |
252 |
|
|
Convert a Cell Reference to Text by
Chuck Buker
Cell A2 contains the text "a100". Cells A5
through F15 contain indirect and offset functions that use
the text in A2 to cause cells A5 through F15 to refer...
|
|
6 |
11,617 |
|
|
count vs counta by
Smith
What is the difference between the formula functions count
and counta?
|
September 22nd, 2003 05:16 PM
by Anon
|
1 |
240 |
|
|
Conditional Formatting by
Monique
Is it possible to use conditional formatting to change the
formatting of a cell based on the value in an adjacent
cell?
For example, if D4 is less than half...
|
September 22nd, 2003 05:17 PM
by Dan E
|
1 |
123 |
|
|
|
|
1 |
383 |