|
|
|
|
7 |
131 |
|
|
sumif formula based on dates by
linnipen
I have the following partial spreadsheet:
Date Total Hours Compensation
1/15/2008 11.00 $133.43
1/22/2008 12.15 ...
|
September 24th, 2008 11:10 PM
by T. Valko
|
2 |
127 |
|
|
|
September 24th, 2008 10:37 PM
by SusanU
|
3 |
166 |
|
|
|
September 24th, 2008 10:20 PM
by Bam
|
3 |
160 |
|
|
|
|
11 |
291 |
|
|
IF statement by
help!
I am not sure what to do here.
I have a worksheet and if C29 - C26 =0, I want the cell to dispay the
amount (for example 20000 - 15000= 50000) but if it is...
|
|
5 |
129 |
|
|
validation in a list by
BoatChief
I am trying to set up a growing list with one column of numerical data that
gets totaled at the bottom. Any new data must not let the total go below -2.
...
|
|
1 |
127 |
|
|
How to remove duplicated data repeated.... by
Kimmie
I am working on a spreadsheet which has many different fields. The first
column is Last Name and the second column is first name. My objective is to
delete...
|
|
7 |
215 |
|
|
Excel Formula by
Stormin
Hi
I wonder if anyone can help me with the following problem.
I have two tabs within a worksheet. The second has a number of colums
including those shown...
|
September 24th, 2008 09:17 PM
by Stormin
|
6 |
124 |
|
|
Search a cell for a specific number by
mpenkala
Hey there,
I'm trying to do the following:
ColB contains either 1,2, or 3
ColC contains a combination of 12,21,23,32,13 or 31
What I'm looking is in ColD, to...
|
September 24th, 2008 08:51 PM
by T. Valko
|
5 |
118 |
|
|
=sumproduct in Excel 2000 by
LPS
In the following "sumproduct" function, what do the "--" mean?
=SUMPRODUCT(--('Evaluation Detail'!$B$7:$B$4990),--('Evaluation
Detail'!$F$7:$F$499="Jane...
|
September 24th, 2008 08:42 PM
by LPS
|
2 |
150 |
|
|
|
|
1 |
110 |
|
|
% by
debs27
How do I get what % increase is between column a and column b?
|
|
4 |
89 |
|
|
excel function problem by
Bob Matthews[_2_]
I have an excel 2003 workbook with several worksheets - each a mirror image
of the others i.e. any particular cell has the same data (not literally)
Cell B6...
|
September 24th, 2008 07:20 PM
by Lori
|
2 |
139 |
|
|
|
September 24th, 2008 07:02 PM
by Lori
|
3 |
123 |
|
|
Date Function by
HARSHAWARDHAN. S .SHASTRI[_2_]
I have a work sheet in which column A is having "Recd On" (Date). column B
is having "Dispatch On" (Date). If there is no holiday Dispatch On date =
Recd On...
|
|
6 |
112 |
|
|
Hghlight the best price for each row by
PaulinaDi
Hi. I have a table where I have to select the lowest price in each row for
several options (suppliers).
e.g. I have values in columns J, O, R, U, X from row...
|
|
5 |
152 |
|
|
Tabbing between protected cells by
Support
I have a document that is a fill in that I have protected the document and
have only certain cells that are available to enter data into. It is setup
so...
|
September 24th, 2008 06:28 PM
by Support
|
0 |
123 |
|
|
|
|
3 |
162 |
|
|
Check value against multiple ranges by
X-Ray
I have a date and want to know in what period this is.
Reference ranges:
period begin end
jan 1/1/2008 14/1/2008
feb 15/1/2008 ...
|
|
3 |
146 |