|
|
Linking Daily Workbooks by
General Specific
I receive daily workbooks from field crews. I would like to compile
daily billing one bi-weekly workbook. I want to link the bi-weekly
summary to the daily...
|
|
1 |
159 |
|
|
|
|
2 |
182 |
|
|
Convert Date to Text by
Michael
Hi Folks - I have a date in the following format: 2008-09-24. Is there a way
to convert this to text so it displays as 2008-09-24? Thanks.
Michael
|
|
2 |
138 |
|
|
Linking by
TOS
I have a spreadsheet with multiple worksheets, one of the worksheets,
recently added, I linked to the main worksheet, so each time I add info it
updates it...
|
September 24th, 2008 04:57 PM
by TOS
|
0 |
137 |
|
|
Value Field Settings for Pivot tables by
Eden397
I want to have the default of my values I place into my pivot to be a SUM
rather than a count at all times in my job. Can I change my pivots to always
sum...
|
September 24th, 2008 04:48 PM
by Eden397
|
0 |
155 |
|
|
Filter Customize date by
Achim
I created a table with "date" and "name" being some of its columns.
Unfortunetly when I filter it by name and want to customize a filter for the
dates...
|
September 24th, 2008 04:35 PM
by Achim
|
3 |
152 |
|
|
Loan Period Calculator Sheet by
garber2007
I have a loan with my parents and we are trying to see how long it will take
to pay back the loan. I see a lot of templates that have you insert the
amount...
|
|
3 |
222 |
|
|
|
|
1 |
184 |
|
|
Special editing by
Mister Ed
When using Excel 2003, I could fill blank cells in a column with contents
from a preceeding cell using the Edit menu. Specifically, after selecting
the...
|
|
1 |
141 |
|
|
Comparing more than two by
Vern
I have a spreadsheet that tracks Date, Salesman and Sale Amount in separate
columns with information over a year. How do I do an analysis of monthly
sales...
|
September 24th, 2008 04:03 PM
by Vern
|
4 |
166 |
|
|
|
|
1 |
140 |
|
|
Changing date format by
PaulinaDi
Month by month I have to work a spreadsheet containing values that should be
in dd/mm/yyyy format but as I get this page from an internal program, I use
to...
|
September 24th, 2008 02:30 PM
by Max
|
3 |
128 |
|
|
|
September 24th, 2008 01:34 PM
by Dave
|
1 |
135 |
|
|
HELP Please - Formula problem by
Form Option Buttons[_2_]
I'm trying to create something like this with option buttons under the
ratings and totals at the bottom. I can't figure out how to get the option
buttons to...
|
|
1 |
250 |
|
|
Displaying Pivot Table Results by
Popey
Hi
Using Excel 2007:
I have a pivot table that produces results from a list of clients entered
into a database each time a client uses my services. The...
|
September 24th, 2008 01:17 PM
by Bam
|
1 |
163 |
|
|
|
September 24th, 2008 01:08 PM
by NSF
|
0 |
143 |
|
|
Calculating hours by
Marty
I am working on a spreadsheet that will calculate the hours worked by a staff
member.
A1 has the start time of 16:00
A2 has a finish time of 01:30 the next...
|
|
5 |
146 |
|
|
Circular References by
Alexey[_2_]
Hi
When i open a worksheet I am getting a Circular reference error
The reference is on $s$6 and the forumula is: =IF(ISERROR(S6),0,SUM(R6/Q6))
Q6 contains the...
|
September 24th, 2008 10:33 AM
by Mike H
|
4 |
163 |
|
|
|
September 24th, 2008 10:31 AM
by Stefi
|
1 |
164 |
|
|
FORMULA HELP ! ! by
GA85
I need a formula to do the following:
If in column 3, a cell says "cash", I need that entire row that contains
"cash" in column 3 to be transferred to...
|
September 24th, 2008 09:57 AM
by Pete_UK
|
1 |
132 |