|
|
Pivot Table Help Please! by
Clint
I created a pivot table from a list of data in excell 2003, and when I add a
new record(row) of data to the list it will not let me refresh the data in
the...
|
December 11th, 2008 04:25 PM
by Clint
|
1 |
88 |
|
|
Please Help! by
Brian
cell a1 has the name Jones in it.
in b1 I would like to have the following formula: =a1 (plus add the
following) !b28
so that the name jones is returned in...
|
December 11th, 2008 04:25 PM
by Max
|
7 |
103 |
|
|
|
|
3 |
109 |
|
|
Button availability by
Jeff Parrott
I have several macros in a workbook and I want to assign them to buttons to
make it easier for new people to use the workbook. However I commonly am
required...
|
|
3 |
88 |
|
|
|
December 11th, 2008 04:11 PM
by komo2kay
|
0 |
308 |
|
|
time elapsed by
tomas
I need a formula that will calculate the amount of time (in hours) that it
takes us to respond to a request, but i need hours of operations and not
include...
|
December 11th, 2008 04:00 PM
by tomas
|
0 |
103 |
|
|
|
|
6 |
115 |
|
|
Read Only by
Carol
I have a workbook and when opened comes up as read-only. If I save with
another name, it does the same thing. Acting like the file is running in the...
|
December 11th, 2008 03:34 PM
by Minnie
|
1 |
82 |
|
|
Pivot report and Filter boxes by
Bony Pony[_2_]
Hi again,
In 2003, if you created a pivot report or graph from a dataset, you had the
option to drive the selections from the chart itself or the underlying...
|
|
1 |
94 |
|
|
Sum/Frequency Formula by
SiH23
In Column B I have listed various product codes, these codes are a mixture of
both alpha and numerical characters, some are duplicated several times in the...
|
December 11th, 2008 03:23 PM
by SiH23
|
6 |
80 |
|
|
|
December 11th, 2008 03:07 PM
by JoAnn
|
0 |
106 |
|
|
Compare two sheets by
CC
Hi
I'm looking for a code to automate some work.
compare two sheets Sheet1 "New data" and sheet2 "old data" and copy the
entire row to sheet3 when...
|
December 11th, 2008 03:01 PM
by CC
|
0 |
76 |
|
|
Extract Cell Comments/Notes to data by
MSpaven75
I have a spreadsheet with Yes/No's a field values and all the meaningful data
as cell comments, I know there is a way to get these notes as cell contents
but...
|
|
7 |
167 |
|
|
Copying and Pasting by
Minnie
I'm trying to copy cells of text from one workbook to another. I select the
cells containing the text, copy and then go to my new workbook and paste.
All ok...
( 1 2)
|
December 11th, 2008 02:53 PM
by stew
|
10 |
126 |
|
|
Formula to determine Fiscal Year by
sa2960
I have the customers start date in Column A, i.e. 4/1/2007.
In Column B I would like to determine what fiscal year they started in.
For example:
If their...
|
December 11th, 2008 02:51 PM
by Max
|
3 |
147 |
|
|
Combining Data on two worksheets by
Gemi
I have a workbook that contains two worksheets: Bookings and Sales. If the
data in columns Bookings A and B match the data in columns Sales A and B I
want...
|
December 11th, 2008 02:14 PM
by Gemi
|
2 |
112 |
|
|
Add cells in pivot by
tommcbrny
Hello,
I would like to create a pivot table based on a web query where the output
of an estimate field is:
1 week
2 days
2 days
1 day, 4 hours
|
|
0 |
98 |
|
|
duplicates by
Pammy
I have a workbook with 10 sheets, on the 11th sheet I would like to create a
formula that would look on these 10 sheets and find the duplicates and bring...
|
|
1 |
81 |
|
|
|
|
1 |
110 |
|
|
I need a formula by
Vercingetorix.XIII[_2_]
I have 2 columns L and N that have payment dates in them, I need a formula
that will scan those 2 columsn because the payments are made in 2 equal
payments...
|
December 11th, 2008 01:36 PM
by Luke M
|
1 |
88 |