|
|
Range Expression by
RobertG
I am currently using this formula "=H19 & I19" in a column to combine two
cells adjacent so cell J19 contains the formula for the contents of H19 &
I19. So...
|
|
2 |
188 |
|
|
Date formula by
J
I need a formula to change to red on a blank cell or a date that is older
than one month from the present date. I am not a techi so please be patient
& step...
( 1 2)
|
|
16 |
388 |
|
|
Zero's plotted in chart? by
Doug
Why would I show zero's for a column of data in my chart that are actually
very large(56869685). Some of my charts have date segments that are missing
when...
|
May 24th, 2010 09:57 PM
by Doug
|
0 |
163 |
|
|
Printing Duplex Copies in Excel by
pack12
I have an Excel workbook with multiple spreadsheets - each sheet is one page.
I'm trying to print duplex copies and selected 'duplex' in my printer...
|
|
1 |
211 |
|
|
run external programs by
Stephen Miller
I want to make another program run from from excel. Is this possible?
|
|
1 |
218 |
|
|
Copy Data...propagate by
Brandy
Good afternoon,
I have a master worksheet ("parent") for which I need to propagate other
worksheets ("child") based on individuals. The master worksheet...
|
|
1 |
284 |
|
|
use VLookup to copy more than 1 cell by
DS
I have been using VLookup in Excel 2003 for some time but I would like to
expand the VLookup results. Instead of just copying one cell to paste as the...
|
|
3 |
389 |
|
|
CONVERT HOURS AND MINUTES TO INT by
3Nails
Calculated hours and mintues from time;
16:00 (4PM) to 19:30 (7:30PM) is 3:30.
How can I convert the results 3 hours and 30 minutes to 3.5 hours?
|
|
3 |
335 |
|
|
Excel 2003 Function Help by
Ryan Hicks
I need help coming up will a function that will average a range in one column
based on if the hours match. Here is my set up.
-------A-------B...
|
|
2 |
246 |
|
|
Limit Series in Chart Data Table by
Legends
Can you specify which series are to be shown in a data table? Currently have
a total of 8 different series and only want 4 to show up in the data table.
|
|
0 |
256 |
|
|
|
|
1 |
293 |
|
|
|
|
0 |
263 |
|
|
|
|
15 |
652 |
|
|
Propagate....copy Data by
Brandy
Good afternoon,
I have a master worksheet ("parent") for which I need to propagate other
worksheets ("child") based on individuals. The master worksheet...
|
May 24th, 2010 06:28 PM
by Brandy
|
0 |
195 |
|
|
Defaulting to date format by
Lea from CA[_2_]
Up until a few weeks ago all was well with Excel07. Then it started to
change the default number format to a date format. When I import a file to
excel or...
|
|
4 |
284 |
|
|
stike through font by
RayNDM83
Hi,
Is there a way to filter by a strike through font?
Thanks,
Ray
|
|
2 |
241 |
|
|
IF ERROR FORMULA by
Candida
=IFERROR(N2,O2),IFERROR(O2,P2),IFERROR(P2,Q2),IFERROR(Q2,R2),"0"
I am using this formula in Column I to Check rows N, O, P,Q, and R to copy
the dollar amount...
|
|
1 |
205 |
|
|
|
|
1 |
222 |
|
|
Sort fails on one column by
christophercbrewster via OfficeKB.com
I've been working with a spreadsheet, using different sorts on it. But
suddenly one of the columns became a no-op for sorting, whether I sort on
that column...
|
|
2 |
252 |
|
|
|
|
1 |
236 |