|
|
|
February 23rd, 2007 03:54 AM
by T. Valko
|
3 |
54 |
|
|
|
|
1 |
95 |
|
|
NEGATIVE DATES IN EXCEL by
TJV1960
I have a spreadsheet with what excel refers to as a negative date, example:
20030112. What I want to do is format the date as 2003/01/12 or 01/12/2003,
but I...
|
|
2 |
64 |
|
|
Subtotals in Pivot Tables by
Fred Smith
I have a pivot table with two row fields. Excel does a nice job of formatting
the table automatically, but it includes a total line when the first field...
|
|
3 |
99 |
|
|
|
|
1 |
86 |
|
|
Most common occurrence of a string by
Mike Archer
Hello.
I need a worksheet function that will tell me the most frequent occurrence
of a single character string in a range of cells, the second most, and the...
|
|
1 |
56 |
|
|
|
|
0 |
50 |
|
|
|
February 22nd, 2007 11:39 PM
by T. Valko
|
3 |
82 |
|
|
|
|
2 |
100 |
|
|
comment indicator line by
Liz
When I ;preview my worksheet, the line from the cell to the comment looks
fine, but when I print it, it is weak.. how do I change that so it is darker?
|
February 22nd, 2007 10:33 PM
by Liz
|
0 |
54 |
|
|
formula needed to sum check marks by
John
Have a look at Countif as you can put a criteria in for the check marks
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any...
|
February 22nd, 2007 09:58 PM
by John
|
0 |
63 |
|
|
formula needed to sum check marks by
veena
thanks!
"john" wrote:
Have a look at Countif as you can put a criteria in for the check marks
--
John
MOS Master Instructor Office 2000, 2002 &...
|
February 22nd, 2007 09:57 PM
by veena
|
0 |
48 |
|
|
SUMIF Not Calculating by
Dlamon
i am using excel 2003 and am trying to use the SUMIF statement with the below
calculation:
=SUMIF('U:\Operations...
|
|
2 |
60 |
|
|
|
February 22nd, 2007 09:54 PM
by John
|
0 |
49 |
|
|
COUNTIF question by
Pierre
Have a spreadsheet containing vendor names in column A, and the column
headings of C,D,E,F and G contain criteria names for evaluating them
in a number of...
|
February 22nd, 2007 09:25 PM
by Pierre
|
3 |
54 |
|
|
|
February 22nd, 2007 09:15 PM
by Toppers
|
1 |
61 |
|
|
SUMIF Not Calculating by
daddylonglegs
Try using SUMPRODUCT, although you'll have to use a defined range rather than
the whole column, e.g.
=SUMPRODUCT(--('U:\Operations...
|
|
0 |
46 |
|
|
Character by
Steved
Hello from Steved
The below formula works perfectly except if no data it leaves a small square
box which siguests to me it is a character, please how do I...
|
February 22nd, 2007 09:04 PM
by Steved
|
3 |
56 |
|
|
Dividing a cell by
Bob
I have a calander that was made and one cell has two dates in it. How can I
put a line between the two numbers and color one half of the cell. I know
it...
|
February 22nd, 2007 08:19 PM
by Joel
|
1 |
44 |
|
|
SUMIF + INDIRECT? by
Davoud
I've used SUMIF for simple calculations such as:
SUMIF($F$32:$F$39,"Contracted",$H$32:$H$39)
on a single sheet.
How would I work that using INDIRECT to...
|
|
4 |
92 |