|
|
|
|
1 |
416 |
|
|
|
February 19th, 2004 06:32 AM
by acw
|
0 |
275 |
|
|
|
|
1 |
110 |
|
|
|
|
1 |
225 |
|
|
SUM COUNTIF problem by
AD Carvajal
In the following spreadsheet, I need to count the number of times "y" appears
in the Guest column when B appears in the Site column. Is there any way to
do...
|
|
1 |
123 |
|
|
incorrect date by
ad place
As of yesterday, 3/16/04, when you format a cell in Excel for the date, the date is not correct...I enter 031704 and the date appears as October 19, 1986. What...
( 1 2)
|
|
13 |
495 |
|
|
Fast Fourier Transform by
Ad Pronk
Dear Madam/Sir,
I have a simple question about the use of the Fast Fourier Transform option
in the Data Analysis package.
1. After the transform of a...
|
|
0 |
97 |
|
|
Formula error by
AD108
I am trying to reference a cell offset from another cell in the sheet I am
working on. The formula below is generating an error. The named range
"SUMRNGE" is...
|
December 11th, 2006 04:45 PM
by PapaDos
|
4 |
68 |
|
|
Number of weeks past in current qtr by
AD108
Hello,
I need to write a formula that returns the number of weeks already past, in
the current quarter. The value returned should include a partial week...
|
December 4th, 2006 01:17 PM
by AD108
|
2 |
59 |
|
|
Make Function ignore 0 and error values by
AD108
I am trying to make the average function ignore 0's and errors. The
following array formula works to ignore the 0's, but I got stuck trying to
make it ignore...
|
November 4th, 2006 07:03 PM
by AD108
|
3 |
65 |
|
|
Look up based on Column and Row headings by
AD108
Hello,
I am trying to write a "look up" that will return the cell value where the
row and column headings in the range match the row and column headings...
|
August 9th, 2006 07:42 PM
by RagDyeR
|
4 |
73 |
|
|
strange error by
AD108
I have the following formula in column "I". I have code that puts a range
of values in to column "G". The values must be pasted as "Values" as the
source...
|
August 9th, 2006 09:22 AM
by Max
|
7 |
97 |
|
|
Activate the top of sheet by
AD108
I need to find a way to make the top of each sheet in a workbook visible
after my code runs. I tried "select" and "activate" but when you select
the sheet,...
|
|
2 |
52 |
|
|
YEAR MONTH DAYS COUNTER by
ad2ad79
Hi,
I have a sheet in which I want to count the year then month and then
days for employee. i.e
Name Date of joining Date of leaving Absent Total
JOHN ...
|
|
8 |
217 |
|
|
YEAR MONTH DAYS COUNTER by
ad2ad79
Hi,
I have a sheet in which I want to count the year then month and then
days for employee. i.e
Name Date of joining Date of leaving Absent Total
JOHN ...
|
|
2 |
139 |
|
|
|
|
1 |
80 |
|
|
|
July 12th, 2006 05:49 PM
by CLR
|
2 |
73 |
|
|
|
|
0 |
91 |
|
|
Count IF by
Adam
Hey Guys, i Want to use COUNTIF function liek this..
(Range, Criteria,
when you use count if, it will just let you do one if statement, (range,...
|
|
1 |
67 |
|
|
|
December 11th, 2008 04:40 AM
by T. Valko
|
1 |
102 |