|
|
|
April 15th, 2009 08:14 PM
by DaveB
|
2 |
102 |
|
|
|
April 15th, 2009 08:06 PM
by AudKen
|
0 |
79 |
|
|
Combining 2 kinds of graphs [how?] by
gordom[_2_]
Hi everyone.
I have a series of data (3 columns and several rows). Here you have the
example:
date & time |value1|value2|
2006-07-11 00:00:00 | -203...
|
April 15th, 2009 08:01 PM
by Luke M
|
2 |
82 |
|
|
2 functions in 1 by
Chey
Right now I have
=DATE(YEAR(V4),MONTH(V4)-1,DAY(V4))
Works great however if I don't have a date in V4 then it comes back NUM. How
can I get rid of that. Can...
|
|
2 |
86 |
|
|
Format Cells for Hexidecimal (custom?) by
Mischief
I have a spreadsheet that requires a user to input a hex value. but the hex
values don't always display and there is no fault checking. (2 issues)
Simple...
|
April 15th, 2009 07:59 PM
by Luke M
|
1 |
121 |
|
|
Pivot Tables by
Brenda @ GM
How do I eliminate obsolete values in my pivot table filters? I reset my
data range, refreshed my table and even created a new pivot table but the
values I...
|
April 15th, 2009 06:49 PM
by Raul
|
4 |
105 |
|
|
|
|
8 |
163 |
|
|
Excel version 3 (1990) by
Jessica
Hi there!
I have an access 97 macro that outputs to excel and is defaulting to the
earliest version in the list, excel 3. I can't seem to find anywhere the...
|
|
3 |
189 |
|
|
stdole32.tld by
Amanda
I have Vista and just installed Office Pro 2007. I get this code when I open
Excel. How can I fix this? I have already uninstalled and reinstalled.
|
April 15th, 2009 06:39 PM
by Amanda
|
0 |
299 |
|
|
VBA Loop to Find then Copy & Paste by
B J Hankinson
I have been trying to figure out how to loop when using a copy formulas and
then find specific words and paste ( I am also using an offset to paste below
the...
|
|
0 |
83 |
|
|
pivot table column order by
Kelli[_3_]
I have a pivot table the # of calls, and type that a person received.
I'd like to show the total number and % in columns next to each other.
What I have...
|
|
0 |
78 |
|
|
VLOOKUP by
BStacy
I have a spreadsheet with a worksheet with several thousand physician names,
addresses, etc.
In another worksheet in the same file I have a list of about 200...
|
|
6 |
108 |
|
|
|
|
3 |
109 |
|
|
|
|
1 |
97 |
|
|
|
|
1 |
77 |
|
|
Formula Question by
Mark
Sorry, began posting earlier and hit send by mistake!
I have a spreadhsheet that I enter orders onto with the requested delivery
date and order volume.
e.g...
|
|
3 |
73 |
|
|
|
|
1 |
78 |
|
|
Text to Rows by
N1KO
I know that converting text to columns is simple but i'm wondering if I can
create a macro to conver text to rows?
Would the easist way to do this be simply...
|
April 15th, 2009 04:33 PM
by N1KO
|
3 |
75 |
|
|
Comments on Protected Sheet - Excel 2003 by
SteveG
Is it possible to protect a worksheet but still allow people to insert
comments to cells. Even if the cell is unprotected, Excel still doesn't
allow...
|
April 15th, 2009 04:29 PM
by SteveG
|
2 |
69 |
|
|
SUMIF Question by
Mark
Hi,
I have a spreadsheet which lists Sales and dates that those orders are to be
delivered on. These dates do not run consecutively on the spreadsheet...
|
|
2 |
75 |