|
|
Pivot Table Refresh Error by
GerryMc
Hi
I'm using Excel 2003 on Windows XP2003
I have been refreshing the same Pivot Tables for a couple of years - I have
created these tables myself. In some...
|
December 4th, 2009 10:09 AM
by GerryMc
|
0 |
114 |
|
|
Printing Problem-Virus? by
k11ngy
I keep posting this but cant see it in the forum under my user name-Apologies
if repeat? I have Excel file that when previewd it wants to print 1 of 1236...
|
|
1 |
101 |
|
|
Reverse Unique Values by
Ken
Excel2003 ...
Col H contains up to 100 unique values
Col D contains Values L1, L2, L3 out to L50 (100 repeats of this set)
In Col C ... I wish a formula to...
|
December 4th, 2009 06:21 AM
by eksh
|
1 |
129 |
|
|
Sum by
Walter Seaton
Is there any way of summing time expressed in minutes and seconds? For
example, I may need the sum of a column containing 5'32'',0'45", 13'03" and
so on.
|
|
1 |
118 |
|
|
Formula for shifting of words by
PL
Hi
I am using Excel 2003.
I want the formula that allows me to shift all the words in a cell 1 spacing
to the left as I have some cells with a spacing...
|
December 4th, 2009 02:49 AM
by Sheeloo
|
1 |
124 |
|
|
incorrect formula result in 2003 by
tennisnut
I am using Excel 2003 SP3 on an XP workstation.
Several times I have simple formulas (i.e., adding a few rows of numbers in
a column), using whole numbers,...
|
|
3 |
117 |
|
|
|
|
1 |
120 |
|
|
Pivot Tables/Charts and common filter by
Kathy L.[_2_]
I have a set of data which is used to generate multiple pivots charts. Each
set of pivot charts also runs from different data worksheets. However, for
each...
|
|
1 |
93 |
|
|
copying columns by
oldjay
I could send this to the Programing form
I want to change the following macro to copy the list to the A column with
formats (color or no color) to a new...
|
December 3rd, 2009 11:56 PM
by oldjay
|
3 |
93 |
|
|
setting up conditional text input by
guy325
I wish to creat a senario that when certain names from a list are typed
within a range of cells, that they appear in a given color
|
December 3rd, 2009 11:56 PM
by guy325
|
4 |
84 |
|
|
|
|
3 |
73 |
|
|
Table of Contents with Page Numbers by
Art Vandelay
G'day all
I have been using Don Guillett's excellent code (copied below) to create a
automatic Table of Contents.
Is there any way to automatically include...
|
|
3 |
105 |
|
|
day of the week and date formula by
Sarah Elliott
Hello
I am looking to write a formula that gives me the difference in hours
between a logged date and time and a closed date and time eg -27/11/2009...
|
December 3rd, 2009 10:55 PM
by Bernd P
|
2 |
85 |
|
|
SEARCH IN SUMPRODUCT by
Lea from CA[_2_]
I am trying to sum column D where column A starts with "61", column B is
either ABC or DEF and column C = North. The result should be 2000 but I am
only...
|
December 3rd, 2009 10:49 PM
by Brian
|
8 |
93 |
|
|
Cell padding by
Jennifer
I have a worksheet with multiple row heights. When I do autofit some of the
words are being cutoff in the rows. How can I adjust to a little extra space
in...
|
|
1 |
100 |
|
|
|
December 3rd, 2009 10:20 PM
by Pete_UK
|
1 |
106 |
|
|
IF OR Formula by
tsmith
In column "G" I have imported dates formatted as such...11/09/2009 9:58:00 AM
I'm in accounting so we go by fiscal month i.e. 10/24/09 thru 11/27/09 is...
|
December 3rd, 2009 09:56 PM
by Pete_UK
|
1 |
81 |
|
|
Calculating Quarters from Dates by
dwake
I am looking at showing the quarter a selective date is in i.e. 9-Dec-09
would be 4Qtr09.s Any code that can do this without having to go in to do it...
|
|
3 |
109 |
|
|
|
December 3rd, 2009 09:31 PM
by Pete_UK
|
1 |
95 |
|
|
|
|
0 |
82 |