|
|
|
|
3 |
70 |
|
|
|
|
5 |
99 |
|
|
|
July 10th, 2008 06:08 PM
by CindyB
|
0 |
74 |
|
|
ACCRINTM() function by
Zumble
Hi,
I know about the ACCRINTM() function in Excel which returns the
Interest-Accrued
between the Issue date and the Settlement date
at a given Rate
...
|
|
1 |
77 |
|
|
|
|
1 |
92 |
|
|
|
July 10th, 2008 04:20 PM
by Zumble
|
3 |
85 |
|
|
Connecting Graphs to a linked worksheet by
MayJuneJuly
Hello, I have a workbook with a main worksheet that has many formulas,
conditions, and data. I would like to create graphs from this data to show
monthly or...
|
|
0 |
95 |
|
|
Worksheet Linked to graphs by
MayJuneJuly
Hello, I am using Mircosoft Office Excel 2003. I have a worksheet with many
columns, formulas, and conditions. This worksheet is linked to sever other...
|
|
0 |
79 |
|
|
List or colour Cells of results by
Jamie
Excel 2007
=If(VLOOKUP(B3,$A$2:$A$10,1,FALSE),COUNTIF($A$2:$A$13,B2),"")
The above formula is looking at a figure in a selected cell then looks in
the...
|
July 10th, 2008 03:28 PM
by Jamie
|
1 |
65 |
|
|
Counting on 2 criteria by
Richie
Hi,
I am trying to count the number of entries in a spreadsheet where i have 2
criteria.
One column contains the dept name eg "Sales" and another is a score...
|
July 10th, 2008 03:26 PM
by PCLIVE
|
2 |
55 |
|
|
Excel Autoformating cells by
Piglet
Is it possible to stop excel from Auto formatting a cell into date fprmat
when you paste date in from the internet?
|
|
3 |
96 |
|
|
a little help? by
BBB
hi,
what i am trying to do is have a validation or list provide options from
another valiadation. this is so that i can select a category "A" in the
first...
|
July 10th, 2008 02:57 PM
by Pete_UK
|
3 |
63 |
|
|
|
|
2 |
81 |
|
|
Help with multi sheet workbook by
Sportinus
I have 12 worksheets that have a players number and name in the first lines
followed by a batting order and position for each player. Each sheet
represents...
|
|
2 |
114 |
|
|
Sumif function by
SRobson
I need to sum data in cell(s) in the same column whose reference is derived
from:
Row: Heading of the column the formula is in
Column: Data that is in column...
|
July 10th, 2008 01:32 PM
by SRobson
|
0 |
69 |
|
|
2 data sets in pivot tables by
SYRINX
Can someone advise - when creating a pivot table showing 2 sets of data in
the summary section in Excel 2003, if you drill down to display only one set
of...
|
July 10th, 2008 01:04 PM
by SYRINX
|
0 |
71 |
|
|
SUMIF function by
Igor[_2_]
Hi
Is it possible to use AND in SUMIF function. I have a simple table with
three columns. The first column contains dates in chronological order. I
want to...
|
|
3 |
74 |
|
|
|
|
2 |
92 |
|
|
|
July 10th, 2008 12:26 PM
by Mike H
|
4 |
82 |
|
|
Find a color value by
Scott
G’Day,
I have a worksheet which users can change the color of a particular cell –
assume C3. What I want to do is change the color of another worksheet...
|
July 10th, 2008 11:59 AM
by Scott
|
5 |
102 |