|
|
Array Function - cell to remain blank by
mare
I am a novice on Excel, however, I don't get easy projects.
I have a spreadsheet where D6:D15 have values. In cell D17
is the Total, which is an average of...
|
|
1 |
189 |
|
|
Dynamic Range by
Brian
I am trying to create a macro and am stuck trying to
figure out how to determine my last column. In cell E3 I
am using the formula =COUNTIF(E4:??,0). Can I...
|
|
5 |
426 |
|
|
|
|
1 |
519 |
|
|
Linking workbooks by
Fawn
I have 4 workbooks with approximately 12 sheets with the information rolling
up into one YTD sheet. What I want to do is to have all 4 of the YTD sheets
on a...
|
|
1 |
357 |
|
|
manual calculation doc by
Sheri
A monthly excel report sent from our corporate office to
our remote location is saved by the sender in Manual
calculation. With no other excel documents open,...
|
|
1 |
370 |
|
|
excel automatic add-ing by
luis
the automatic add-ing stop working. i uninstalled the program and reinstalled again, but did not fix the problem. I used tthe fix and repair option but did...
|
|
1 |
295 |
|
|
Pivot Table and Countif Function by
Amiram
ID B Month
A1 Pass Feb
A1 Pass Feb
A1 Pass Feb
A3 Fail Feb
A4 Fail Feb
A4 Pass Feb
A4 Fail Feb
A4 Pass Feb
A1 Pass Jan
|
November 11th, 2003 02:29 PM
by Amiram
|
0 |
319 |
|
|
|
November 11th, 2003 01:58 PM
by Mahesh
|
0 |
220 |
|
|
|
|
1 |
378 |
|
|
Coloring Subtotals by
Scott V
How can i automatically color subtotals? Keep in mind
that the subtotal rows will constantly be changing.
Scott
|
|
1 |
117 |
|
|
negative hour/min values by
emily
Is there a way in Excel I can enter hour/minute values as
negative and therefore perform calculations on these
figures? I am developing a timesheet which...
|
November 11th, 2003 03:44 AM
by emily
|
4 |
364 |
|
|
"dated if" statement by
todd
IF(AND(DATEDIF(Q14,V$7,"Y")-2,$C14=$C$1),($AA$2*8/24)*
($E14/40)
Hi, I am working on a set of dated if statement that I
have copied from an old worksheet. ...
|
November 11th, 2003 01:50 AM
by WShelton
|
3 |
166 |
|
|
Highest and lowest value from column by
DrB
I have a column of numbers including blanks where I want to put into another
cell the highest and into another cell the lowest (ignoring the blank or a
zero...
|
November 11th, 2003 01:39 AM
by DrB
|
2 |
149 |
|
|
Date format in cell by
Raymond Reedy
I set the format for the cell to be a date in the form 11/22 (no year) =
and=20
enter 11/15. Excel changes it to 11/15/2003. I do not want the year....
|
|
1 |
156 |
|
|
Excel/Percentage by
David
I have recently upgraded excel 97 to 2002 and have noticed
that when i formated cells for percentage it multiplies
what i put in by 100 to create the...
|
|
1 |
92 |
|
|
Unpivot by
Rich C
Is there a way to take a pivot table and 'unpivot' it back
to a normal spreadsheet?
|
|
1 |
121 |
|
|
Convert seconds to mm:ss by
Larry
I have a worksheet that shows avg. elapsed time in seconds
as a numerical value (ex. 507.84275 is 507 seconds). I
need to convert this to a mm:ss format...
|
|
2 |
330 |
|
|
|
|
1 |
234 |
|
|
Credit Card Number Suppression by
Dana
I have an existing workbook that contains a confirmation
that gets faxed to customers to sign off approving credit
card charges. The credit card # is typed on...
|
|
7 |
591 |
|
|
How to convert text to numbers? by
T Bennett
I am importing a pile of numbers from Access to Excel. The problem is,
Access puts numbers in with the quote mark. If I copy a column then paste
special -...
|
|
1 |
280 |