|
|
|
|
1 |
79 |
|
|
Subtotaling non-contiguous cells by
David N. Ballew Jr.[_2_]
I am trying to figure out the syntax for a subtotal formula that subtotals
non-contiguous cells. I am using Excel 2003. If I use the Sum function as in
the...
|
|
2 |
90 |
|
|
Figuring military time for total hours by
David Nelms
Helping someone out with a worksheet that figures time (in military
time) for use at weekend race tracks. Generally they have two days so it
was easy with 2...
|
|
3 |
270 |
|
|
Unsharing a workbook in Excel 2007 by
David Newton
I just shared a excel document on my server to test it out and found all the
insert commands greyed out. I need to find a way to insert pictures.
I then...
|
|
0 |
106 |
|
|
cell color by
David NL
Hello best excellers.
I have a sheet for my empolyees with the days on which they should work.
I want to change the color of the cell automatically to blue...
|
September 28th, 2005 10:15 PM
by Ray A
|
2 |
89 |
|
|
daily output list of employees by
David NL
Hello excellers,
I seek a solution for my problem and you are the only ones who can help.
I have a year-list of employees for each day ( 100 persons ).
Daily...
|
|
1 |
103 |
|
|
|
|
2 |
134 |
|
|
|
January 21st, 2006 10:37 PM
by vezerid
|
2 |
80 |
|
|
|
February 21st, 2005 05:57 PM
by David P
|
0 |
101 |
|
|
MS Query - Alias syntax by
David P
Hi All,
Does anyone know what is the correct syntax to rename a field name in MS
Query? I go thru the wizard and try to modify the sql. The alias or 'as'...
|
|
3 |
120 |
|
|
Ghost Blank Cell References by
David P
Can anyone explain why there are "ghost" blank cells when a pivot table is
present on a worksheet.
If you have a pivot table that starts in B1 and if you...
|
|
1 |
138 |
|
|
|
|
1 |
256 |
|
|
|
|
2 |
54 |
|
|
WEEKNUM function by
david p
ISO standard says Jan. 3, 2005 is week 1 day 1. Excel says
it is week 2 day 1.
|
March 13th, 2004 03:24 PM
by david p
|
8 |
542 |
|
|
|
|
2 |
81 |
|
|
In Excel, lists should be sorted. by
David Paul
In Excel, often, I create a list (Data, List), and the data is linked to
another source.
I suggest that when creating the list, one has the option of sorting...
|
|
1 |
97 |
|
|
COPYING TIME FORMATED CELL TO ANOTHER by
DAVID PEARSON
I HAVE FORMATED TWO COLUMNS USING THE DATE FORMAT
FUNCTION. I WANT THE DATE ENTERED ("COPY FROM"),TO DISPLAY
IN A DIFFERENT CELL ON THE SAME ROW IN A DIFFERENT...
|
|
1 |
506 |
|
|
nested if statements - multiple variables by
David Pelizzari
I am attempting to write an if statement to check values in two columns, and
return a value based on the two.
column A is difference between two dates (today...
|
|
2 |
164 |
|
|
lookup mutliple values to return one value by
David Pelizzari, IS Manager
I am trying to find a way to lookup more than one value in a row (vlookup) to
return a value in a corresponding row. We have a list of values in column...
|
February 7th, 2006 01:26 AM
by Max
|
1 |
254 |
|
|
|
|
15 |
207 |